日期:2014-05-16 浏览次数:20662 次
数据导出到文件,网上很多帖子都是乱写,郁闷一下,这么简单的东西都乱写!
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]
?