MySQL 如何使用mysqlimport将数据上传到多个MySQL表中？

通过mysqlimport的帮助，我们可以将数据上传到多个MySQL表中。下面的示例中说明了这一点。

阅读更多：MySQL 教程

示例

假设我们要从两个数据文件student1_tbl.txt和House.txt上传以下数据-

1     Saurav      11th
2     Sahil       11th
3     Digvijay    11th

和House.txt

1     Furniture
2     Television
3     Refrigerator

以下是我们要将上述数据上传到的MySQL表-

mysql> DESCRIBE Student1_tbl;
+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| RollNo | int(11)     | YES  |     | NULL    |       |
| Name   | varchar(20) | YES  |     | NULL    |       |
| Class  | varchar(20) | YES  |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+
3 rows in set (0.06 sec)

mysql> DESCRIBE House;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| Sr    | int(11)     | YES  |     | NULL    |       |
| Name  | varchar(20) | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

现在，借助以下命令，我们可以将数据上传到这两个表中-

C:\mysql\bin>mysqlimport -u root query C:/mysql/bin/mysql-files/student_tbl.txt C:/mysql/bin/mysql-files/house.txt
query.student_tbl: Records: 3 Deleted: 0 Skipped: 0 Warnings: 0
query.house: Records: 3 Deleted: 0 Skipped: 0 Warnings: 0

mysql> Select * from House;
+------+--------------+
| Sr   | Name         |
+------+--------------+
| 1    | Furniture    |
| 2    | Televisoin   |
| 3    | Refrigerator |
+------+--------------+
3 rows in set (0.00 sec)

mysql> Select * from student1_tbl;
+--------+---------+-------+
| RollNo | Name    | Class |
+--------+---------+-------+
| 1      | Saurav  | 11th  |
| 2      | Sahil   | 11th  |
| 3      | Digvijay| 11th  |
+--------+---------+-------+
3 rows in set (0.00 sec)