linux服务器通过mailx邮件发送附件到指定邮箱

shell脚本查询数据库
#!/bin/bash
HOSTNAME="数据库IP"
PORT="端口"
USERNAME="用户"
PASSWORD="密码"
DBNAME="库名"
select_sql="SELECT  
       DATE_FORMAT(t.orderdate,'%Y-%m-%d') as '日期', 
       t.store_name as '店铺名称', 
       t.store_id, 
       (case when t.channel='1' then '线下' else '线上' end) as '渠道', 
       t.type_name as '商品品类', 
       t.product_name as '商品', 
       t.brand as '品牌',
       count(t.order_id) as '订单数', 
       sum(t.units * t.price) as '订单总金额'
FROM mk_mrp_order t 
where DATE_FORMAT(t.orderdate,'%Y-%m-%d')=date_format(DATE_SUB(CURDATE(),INTERVAL 1 day),'%Y-%m-%d')
group by  
         DATE_FORMAT(t.orderdate,'%Y-%m-%d'),
         t.store_id,
         t.store_name,
         t.channel,
         t.type_id,
         t.type_name,
         t.product_id,
         t.product_name,
         t.brand
order by DATE_FORMAT(t.orderdate,'%Y-%m-%d') desc;"  
mysql -h${HOSTNAME} -p${PASSWORD} -u${USERNAME} -P${PORT} -D ${DBNAME} -e "${select_sql}"
#!/bin/bash
HOSTNAME="数据库IP"
PO