MySQL select into outfile 语法
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE “/opt/abc.txt" INTO TABLE table_name FIELDS TERMINATED BY ',' (column1, column2,colum3);
mysql> SELECT * FROM table1 INTO OUTFILE 'data.txt'
F
转载
2014-07-01 22:04:01 ·
6405 阅读 ·
0 评论