Revision: 59232
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at August 26, 2012 06:00 by kirkfortune
Initial Code
LOAD DATA LOCAL INFILE '/file.csv' INTO TABLE `table_name` FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1,field2,etc)
Initial URL
Initial Description
ensure the url to the csv file is in the root of your file system (eg: C:/mycsvfile.csv)
Initial Title
Insert into mysql from csv file
Initial Tags
Initial Language
MySQL