How do I import delimited data into MySQL?:

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”;

Comments are closed.