mysql导出表为csv

SELECT * INTO OUTFILE '/path/to/your/file.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM your_table;

mysqldump -u username -p database_name table_name --fields-terminated-by=',' --fields-enclosed-by='"' --lines-terminated-by='\n' > /path/to/your/file.csv

GRANT FILE ON *.* TO 'your_user'@'localhost';

SELECT * INTO OUTFILE '/path/to/your/file.csv'
CHARACTER SET utf8mb4
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM your_table;

SELECT CONCAT_WS(',', column1, CAST(column2 AS CHAR(255))) INTO OUTFILE '/path/to/your/file.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM your_table;