mysql导入数据到新表_mysql 复制表结构 / 从结果中导入数据到新表
发布时间：2022-10-15 11:08:24 所属栏目：MySql教程 来源：
导读： 这只会复制结构:
mysql> create table a like mysql1;
Query OK, 0 rows affected (0.03 sec)
mysql> desc a;
+----------+----------+------+-----+---------+-------+
mysql> create table a like mysql1;
Query OK, 0 rows affected (0.03 sec)
mysql> desc a;
+----------+----------+------+-----+---------+-------+
|
这只会复制结构: mysql> create table a like mysql1; Query OK, 0 rows affected (0.03 sec) mysql> desc a; +----------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+----------+------+-----+---------+-------+ | user | char(80) | NO | | | | | host | char(60) | NO | | | | | password | char(41) | NO | | | | +----------+----------+------+-----+---------+-------+ 3 rows in set (0.00 sec) mysql> select * from a; Empty set (0.00 sec) mysql> 这除了复制结构， 还会复制结果集： mysql> create table t8 select user,host from mysql.user; Query OK, 1 row affected (0.03 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> desc t8; +-------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+----------+------+-----+---------+-------+ | user | char(80) | NO | | | | | host | char(60) | NO | | | | +-------+----------+------+-----+---------+-------+ 2 rows in set (0.01 sec) mysql> select * from t8; +------+-----------+ | user | host | +------+-----------+ | root | localhost | +------+-----------+ 1 row in set (0.00 sec) mysql> 用法例子： #创一个一样的表 create table a_back like mysql.user; #导入另一个表中的所有数据 insert into a_back select * from mysql.user （编辑：PHP编程网 - 钦州站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐
浙公网安备 33038102330484号