How do i import a csv file into MySQL?

FTP the csv file up to your web root, and login the PHPMyAdmin. Drop this in the ‘SQL’ box and tweak the table / field names.

LOAD DATA LOCAL INFILE '/importfile.csv' INTO TABLE table_name FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1, filed2, field3);

Browse your table.

Drink tea.

Import CSV data

Posted on 14th October 2007 to Code. Subscribe to follow comments on this post.