要在MySQL中将数据导出为CSV格式,您可以使用SELECT ... INTO OUTFILE语句。以下是一个简单的示例:
SELECT col1, col2, col3
INTO OUTFILE '/path/to/output/file.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM table_name;
这将选择表"table_name"中的列"col1","col2"和"col3",并将其写入名为"/path/to/output/file.csv"的文件中。