목록CSV (1)

LukeHan 의 잡다한 기술 블로그

[MariaDB] Table Data Export to CSV File

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
Database/Mysql 2024. 7. 5. 20:00
Prev 1 Next