load csv into mysql,MYSQL使用LOAD DATA INFILE从csv导入数据

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 table columns?

When I execute

LOAD DATA INFILE'abc.csv' INTO TABLE abc

this query adds all data to the first column.

Please suggest auto syntax for importing data to Mysql.

解决方案

You can use LOAD DATA INFILE command to import csv file into table.

LOAD DATA LOCAL INFILE 'abc.csv' INTO TABLE abc

FIELDS TERMINATED BY ','

ENCLOSED BY '"'

LINES TERMINATED BY '\r\n'

IGNORE 1 LINES

(col1, col2, col3, col4, col5...);