SELECT ？ INTO OUTFILE （as CSV）

在select 查询from 前加：

-----------------------------

INTO OUTFILE 'G:/wamp2/bin/mysql/mysql5.5.24/outfile/tst_position.txt'

  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'

  LINES TERMINATED BY '\n'

------------------------------

导出csv

（在Windows ，用正斜线）

-----------------------------

also see mysqldump if not for temp table on-the-fly

also see http://stackoverflow.com/questions/9366875/mysql-insert-into-select-very-slow

转载于:https://my.oschina.net/jsyang888/blog/114112