mysql CSVでデータの吐き出し
mysql CSVでデータの吐き出し
SELECT * FROM users
ORDER BY id
INTO OUTFILE
"/tmp/users.csv"
FIELDS
TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES
TERMINATED BY '\r\n'
;メモに
Follow me!
静岡県浜松市でWEBシステム開発会社をしている社長のブログ
mysql CSVでデータの吐き出し
SELECT * FROM users
ORDER BY id
INTO OUTFILE
"/tmp/users.csv"
FIELDS
TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES
TERMINATED BY '\r\n'
;メモに
Follow me!
