mysql - 从带有标题的 MySQL 导出 CSV 文件的排序问题

Question

我想从 MYsql 导出到按两列排序的 csv，我找到了这个教程:http://homepage.mac.com/kelleherk/iblog/C711669388/E20060511141025/index.html但它不适合我。如果我使用不带括号的语句，它会进行排序，但使用我的标题作为数据行。但是如果我使用括号，它根本不会做任何排序。可能是什么问题？我的查询是:

SELECT 'type' ,'brand' ,'timecenter_hu' ,'karorauzlet_hu' ,'karorauzlet_hu_diff',
'karorauzlet_hu_link', 
UNION (SELECT type, brand, timecenter_hu, karorauzlet_hu,
karorauzlet_hu_diff, karorauzlet_hu_link 
INTO OUTFILE 'c://result.csv'
FIELDS TERMINATED BY ',' 
OPTIONALLY ENCLOSED BY '"' LINES 
TERMINATED BY '\n' FROM 
result ORDER BY brand);

Answer 1

我认为您需要一个额外的查询来导出到 CSV:

SELECT *
FROM 
    (SELECT 'type' ,'brand' ,'timecenter_hu' ,'karorauzlet_hu' ,'karorauzlet_hu_diff' ,'karorauzlet_hu_link'
     UNION 
    (SELECT type, brand, timecenter_hu, karorauzlet_hu, karorauzlet_hu_diff, karorauzlet_hu_link 
        FROM result
        ORDER BY brand)) AS tmp
INTO OUTFILE 'c://result.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';