MySQL
SQL
CSV

MySQLのSELECT文でcsvを出力する

More than 3 years have passed since last update.

SELECT * FROM users

INTO OUTFILE '/tmp/users.csv'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"';

こんな感じで出せます