mysql - 将数据库记录导出为 CSV 文件

Question

有没有办法使用命令行语法从 Mysql Workbench 将数据库记录导出为 CSV 文件？

Answer 1

SELECT orderNumber, status, orderDate, requiredDate, comments 
FROM orders
WHERE status = 'Cancelled'
INTO OUTFILE 'C:/tmp/cancelled_orders.csv'
FIELDS ENCLOSED BY '"' TERMINATED BY ';' ESCAPED BY '"'
LINES TERMINATED BY '\r\n';

更多信息在这里:

http://www.mysqltutorial.org/mysql-export-table-to-csv/