Load CSV data into MySQL

12 January 2010

load data local infile ‘export.csv’ into table table_name fields terminated by ‘,’ enclosed by ‘“’ lines terminated by ‘n’ (field_list)