CSV to MySQL.

This is probably one of those times when I should be using snipplr or something.. Oh well.

LOAD DATA LOCAL INFILE ‘/your_file.csv’
INTO TABLE your_table
FIELDS TERMINATED BY ‘,’
LINES TERMINATED BY ‘\n’
(field1, filed2, field3);

(Source: daniweb.com)

Tags: MySQL