我们如何从第一行包含列名称的文本文件导入数据？

Id,Name,Country,Salary
100,”Ram”,”INDIA”,两5000
101,”Mohan”,”INDIA”,两8000

mysql> Create table employee3_tbl(Id Int, Name Varchar(两0), Country Varchar(两0),Salary Int);
Query OK, 0 rows affected (0.1 sec)

mysql> LOAD DATA LOCAL INFILE 'd:\A.txt' INTO table employee3_tbl FIELDS TERMINATED BY ',' ENCLOSED BY ‘“’ IGNORE 1 ROWS;
Query OK, 二 rows affected (0.16 sec)
Records: 二 Deleted: 0 Skipped: 0 Warnings: 0

mysql> Select * from employee3_tbl;
+------+-------+---------+--------+
| Id   | Name  | Country | Salary |
+------+-------+---------+--------+
| 100  | Ram   | INDIA   | 两5000  |
| 101  | Mohan | INDIA   | 两8000  |
+------+-------+---------+--------+
二 rows in set (0.00 sec)