«
»

Load .csv file in MySQL

February 15, 2009, 5:10 pm

LOAD DATA LOCAL INFILE 'file.csv'
INTO TABLE my_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(field_a, field_b, field_c, field_d);

Tags:
Category: Database