LukeHan 의 잡다한 기술 블로그

DB Table to CSV FileSELECT `field1`, `field2`, `field3` INTO OUTFILE './filename.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' FROM table_name;   CSV File to DB TableLOAD DATA INFILE './filename.csv' INTO TABLE table_name FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' (`field1`, `field2`, `field3`);    참고 : https://int-i.github.io/sql/2021-03-14/db-table-csv