mysql retrieve data in Shell.

get_data_mysql.sh

function run_Mysql()
{
mysql --default-character-set=utf8 \
        -h 192.168.156.120 \
        -u data -p'PIN239!@#$%^&8' \
        -D optimus \
        -e "

select platform,  day
    , SUM(bid) as bid , SUM(imp) as imp
    , sum(click) as click
    , sum(adv_cost) as cost

from report.rpt_effect_day

where day > ADDDATE(SYSDATE(), INTERVAL - 8 day) and platform = 'XiaoMi'

group by platform, day

order by day

"  > output_mysql.data
}

run_Mysql;