Johnathan Kong

The easiest way that I’ve found to import a csv file into a table is to create a table that has the exact columns as the file, then run the following command:

1
2
3
4

LOAD DATA LOCAL INFILE '<full path with file name>' 
INTO TABLE import 
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n'