Jordan Savant # Software Engineer

Load a CSV file into a table

mysql> LOAD DATA INFILE ['/tmp/filename.csv'] REPLACE INTO TABLE [table_name] FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' ( field1, field2, field3, ... );