csv mysql

Import CSV into MySQL This is a simple version of LOAD DATA command to import simple CSV file into MySQL table. It look only .02 seconds to import 40+ records. LOAD DATA INFILE ‘c:\datafolder\t_order_details.csv” INTO TABLE t_order_details FIELDS TERMINATED BY ‘;’ LINES TERMINATED BY ‘\n’ IGNORE 1 ROWS; Assuming you have the first row as…