数据导出到文件,网上很多帖子都是乱写,郁闷一下,这么简单的东西都乱写!
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]