[MariaDB] Table Data Export to CSV File

 

DB Table to CSV File

SELECT `field1`, `field2`, `field3` INTO OUTFILE './filename.csv'
  FIELDS
    TERMINATED BY ','
    OPTIONALLY ENCLOSED BY '"'
  FROM table_name;

 

 

 

CSV File to DB Table

LOAD 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