MYSQL import data from csv using LOAD DATA INFILE - Stack Overflow
I am importing some data of 20000 rows from a CSV file into Mysql. Columns in the CSV are in a different order than MySQL table's columns. How to automatically assign columns corresponding to Mysql ... You need to understand LOAD DATA INFILE syntax. ......