Import and Export CSV in MySQL

CSV Import / Export

Import (LOAD DATA)

LOAD DATA INFILE 'students.csv'
INTO TABLE students
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;

Export (INTO OUTFILE)

SELECT * FROM students
INTO OUTFILE 'out.csv'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';

Summary

• LOAD DATA INFILE imports a CSV into a table.
• SELECT ... INTO OUTFILE exports query results to a CSV.

CSV Import / Export

Import (LOAD DATA)

LOAD DATA INFILE 'students.csv'
INTO TABLE students
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;

Export (INTO OUTFILE)

SELECT * FROM students
INTO OUTFILE 'out.csv'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';

सारांश

• LOAD DATA INFILE CSV को table में import करता है।
• SELECT ... INTO OUTFILE query results CSV में export करता है।