1、使用into outfile ‘保存到操作系统的外部文件路径‘
mysql -uroot -p123456 -hhostname -P3306
select column_name_list from table_name where condition into outfile ‘/home/glc/tmp/yes.csv‘;
2、使用 mysql -e "select column_name_list from table_name where condition " > no.csv
原文：https://www.cnblogs.com/igoodful/p/11697899.html