mysql导出 csv文件

root@localhost: hrms>select * from student into outfile 'c:\a.csv'
    -> fields terminated by ','
    -> optionally enclosed by ""
    -> escaped by '\\'
    -> lines terminated by '\n'
    -> ;
原文地址:https://www.cnblogs.com/zhenmingliu/p/2484656.html