MysqlでSelectの結果をCSVにエクスポートする

Ayumi

10 years ago

こんな感じで、SELECT分の後にINTO OUTFILEを追加してあげればOKです。

SELECT * FROM user
WHERE status = 1 
ORDER BY id ASC
INTO OUTFILE '/tmp/status_user.csv'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"';

SELECT * FROM user

WHERE status = 1

ORDER BY id ASC

INTO OUTFILE '/tmp/status_user.csv'

FIELDS TERMINATED BY ','

OPTIONALLY ENCLOSED BY '"';