All posts tagged in: csv mysql

How to quickly import CSV file into MySQL table


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’ ..

Menu Title