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 '"';

こんな感じで出せます