본문 바로가기

Programming/DB

mysql table을 csv로 옮기기

SELECT * INTO OUTFILE 'file_name.csv'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM table_name;