通过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)
以上就是如何使用mysqlimport将数据上传到多个MySQL表中?的详细内容,更多请关注php中文网其它相关文章!
已抢65117个
抢已抢28518个
抢已抢15410个
抢已抢7729个
抢已抢9631个
抢已抢19608个
抢