Archive for February, 2010

mySQL csv import via LOAD DATA INFILE

Well it’s actually quite simple. That sample worked for me like a charm: LOAD DATA INFILE “C:\\\\us_mag_sizes.csv” INTO TABLE support_sizes_US FIELDS TERMINATED BY “,” OPTIONALLY ENCLOSED BY “””” LINES TERMINATED BY “\r\n” IGNORE 1 LINES LOAD DATA INFILE “C:\\\\time_pojas.csv” INTO TABLE pt_time FIELDS TERMINATED BY “,” OPTIONALLY ENCLOSED BY “””” LINES TERMINATED BY “\r\n” IGNORE […]

Posted on February 11, 2010 at 18:33 by admin · Permalink · Leave a comment
In: English, sql