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 1 LINES
(name_full,time,name)