mysql -umaster -hxx.xx.xx.xx -p -e "set names utf8; use xxxdb;select * from t_order where t_order.userId = (select t_user.id from t_user where t_user.phone = '132404');" >test.xls
set names utf8防止中文乱码
从数据库导出数为生成excel表
mysql -umaster -hxx.xx.xx.xx -p -e "set names utf8; use xxxdb;select * from t_order where t_order.userId = (select t_user.id from t_user where t_user.phone = '132404');" >test.xls
set names utf8防止中文乱码