Return to Snippet

Revision: 4580
at January 24, 2008 11:51 by Abe


Updated Code
LOAD DATA LOCAL INFILE 'file.csv' INTO TABLE `locations` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\ r\ n'

Revision: 4579
at January 11, 2008 17:50 by Abe


Initial Code
LOAD DATA LOCAL INFILE 'file.csv' INTO TABLE `locations` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '
'

Initial URL


Initial Description


Initial Title
Load CSV file to SQL DB

Initial Tags
sql, csv

Initial Language
SQL