MySQL How to bulk import multiple Excel files, the fields are the corresponding

MySQL How to bulk import multiple Excel files, the fields are the corresponding

Reply content:

MySQL How to bulk import multiple Excel files, the fields are the corresponding

Navicat

Navicat seems to have this function.

Or you can first convert Excel to CSV, and then import the data with the following SQL

#从文件导入至数据表LOAD DATA LOCAL INFILE 'c:/test.csv' INTO TABLE testFIELDS   TERMINATED BY ','   ENCLOSED BY "'"   ESCAPED BY "'"LINES   TERMINATED BY '\r\n'IGNORE 1 LINES;

Reference: Http://dev.mysql.com/doc/refm ...

