mysql里怎么快速导出一张表为csv文件?

Question

我是很粗暴的select * from 表. 然后全fetch出来.再写成文件.

但是个人感觉,速度不说跟mysqldump比了,跟phpmyadmin的导出比都慢了不止一点. 现在只好用笨办法,直接dump出来一张表,然后用awk处理.

感觉还是好傻的样子. 求教这里该怎么做才是合理的方法.

Answer 1

Try select into outfile:

SELECT * INTO OUTFILE "test.csv"
FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'
FROM books;

Commas in fields will be quoted by slashes:

$ cat test.csv
1,abc\,def
2,abcdef