How do I import delimited data into MySQL?:
LOAD DATA INFILE “./ImportData.csv” INTO TABLE table1 FIELDS TERMINATED BY “,” OPTIONALLY ENCLOSED BY “””” LINES TERMINATED BY “\r\n”;
How do I import delimited data into MySQL?:
LOAD DATA INFILE “./ImportData.csv” INTO TABLE table1 FIELDS TERMINATED BY “,” OPTIONALLY ENCLOSED BY “””” LINES TERMINATED BY “\r\n”;