mysql - 将 MySQL 表导出为 CSV

Question

根据MySQL documentation您应该能够将数据导出到 CSV 文件:

The mysqldump command can also generate output in CSV, other delimited text, or XML format.

但是文档没有透露怎么办？有人可以帮忙吗？

Answer 1

SELECT * FROM `database_name`.`table_name` INTO OUTFILE 'path_to_folder/filename.csv' FIELDS ENCLOSED BY '"' TERMINATED BY ';' ESCAPED BY '"' LINES TERMINATED BY '\r\n';"

这就是你要做的。