从数据库导出数为生成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防止中文乱码

原文地址:https://www.cnblogs.com/bass6/p/5994630.html