MySQL:将表写入csv文件

Question

我有一个简单的查询，它从 MySQL 表中选择列并将其写入 csv 文件。

 (select 'tempid', 'region', 'puma')
 union all
 select * from (select tempid, region, puma_2000 from tableA order by tempid  limit 
 4000000) a
  into outfile 'c:/models/output.csv'
 FIELDS TERMINATED BY ','
  optionally ENCLOSED BY '"'
 LINES TERMINATED BY '\r\n';

它给我“错误 1064。您的 SQL 语法有错误。”。我尝试了一些改变，但似乎没有任何效果。我使用的MySQL版本是5.5。您在查询中看到明显的错误吗？

Answer 1

行中:

select * from (select tempid, region, puma_2000 from tableA order by tempid,  limit

尝试删除 tempid 之后和 limit 之前的逗号:

select * from (select tempid, region, puma_2000 from tableA order by tempid limit