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'
    -> ;
posted @ 2012-05-05 12:01  刘振明  阅读(364)  评论(0编辑  收藏  举报