mysql数据导出到文件

数据导出到文件，网上很多帖子都是乱写，郁闷一下，这么简单的东西都乱写！

SELECT * INTO OUTFILE "/usr/local/bak/data.dmp"
FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'
FROM tablename;

 

参考

SELECT [select options go here] INTO {OUTFILE | DUMPFILE} filename
EXPORT_OPTIONS
FROM table_references [additional select options go here]