MySQLのテーブルをエクスポート

コマンドで

SELECT * FROM table
INTO OUTFILE "foo.csv"
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\r'