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 […]