mysql to csv format

use command output talble for csv

mysql -uroot 

mysql>

 select yourfield from youtable   
 into outfile '/tmp/test.csv'   
 fields terminated by ',' optionally enclosed by '"' escaped by '"'   
 lines terminated by '\r\n';   

接下來在 /tmp/test.csv 就可以看到該檔案了

vim /tmp/tset.csv