mysql -hlocalhost -uroot -ppassword console_v2 --default-character-set=utf8 -e “select * from ad left join ad_schedule s on ad.id = s.ad_id” > ‘/data1/dataservice/zsp/ad_info.txt’