通过Mysqlimport的帮助,我们可以将数据上传到多个mysql表中。下面的示例中有说明:示例假设我们想要从两个数据文件student1_tbl.txt上传以下数据:1 Saurav 11th 2 Sahil
通过Mysqlimport的帮助,我们可以将数据上传到多个mysql表中。下面的示例中有说明:
假设我们想要从两个数据文件student1_tbl.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)
--结束END--
本文标题: 如何使用mysqlimport将数据上传到多个MySQL表中?
本文链接: https://www.lsjlt.com/news/436882.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-16
2024-05-16
2024-05-16
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0