数据 cal null type records ted fault set
这只会复制结构:
- 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>
mysql 复制表结构 / 从结果中导入数据到新表
来源: http://www.bubuko.com/infodetail-2130498.html