mysql - 如何在 MySQL INTO OUTFILE 命令中设置日期时间格式？

Question

有没有办法在 MySQL INTO OUTFILE 命令中显式设置 DATE/DATETIME/TIMESTAMP 类型列的格式？

select * from orders LIMIT 100
INTO OUTFILE 'c:/tmp/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '
';

也许在 shell 或命令本身？

Answer 1

这里的关键是查询的第一部分，select几乎是一个功能齐全的标准选择。所以你可以不用 select *

SELECT col1, col2, date_format(date_col, 'someformat') ...
INTO OUTFILE 'c:/tmp/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '
';

并以您选择的格式生成输出。 DATE_FORMAT 引用:

https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_date-format