#!/bin/bash
#设置mysql的连接
HOSTNAME="127.0.0.1"
PORT="3306"
USERNAME="xxxx"
PASSWORD="xxxx"
DBNAME="abm"
TABLENAME="abm_audience"
DATE=`date  "+%Y-%m-%d"`

select_sql="select * from t_log order by create_date desc;"

#执行mysql
/usr/local/mysql/bin/mysql -h${HOSTNAME}  -P${PORT}  -u${USERNAME} -p${PASSWORD} abm -e "${select_sql}" > $DATE.txt

#设置sendemail
email_reciver=xxxxx@qq.com
email_sender=xxxxx@qq.com
email_username=xxxxx@qq.com
email_password=xxxxx
email_smtphost=smtp.qq.com
email_title="title"
email_content="content"

/usr/local/bin/sendEmail -f ${email_sender} -t ${email_reciver} -s ${email_smtphost} -u ${email_title} -xu ${email_username} -a $DATE.txt -xp ${email_password} -m ${email_content} -o message-charset=utf-8