MySQL + SQL · Lesson 105

Import and Export CSV in MySQL

CSV Import / Export

MySQL can read data from a CSV file into a table and write query results out to a CSV — useful for Excel and bulk data.

Import (LOAD DATA)

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

IGNORE 1 ROWS skips the header line of the CSV.

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.