my sql

 pasting

mysql命令行操作大全

https://www.cnblogs.com/offcos/articles/10368554.html

mysql 导出select语句结果到excel文件

https://www.cnblogs.com/awakenedy/articles/9796463.html

mysql -h127.0.0.1 -uroot -p123 -e "select * from edu_iclass_areas" test > /Users/zhengcanrui/WORK/test/test.xls

pasting