mysql表的复制

mysql> select * from stu;
+----+--------+----------+---------------------+---------------------+------+
| id | sname  | class_id | birthday            | updated_at          | sex  |
+----+--------+----------+---------------------+---------------------+------+
|  1 | 李广   |        1 | 1998-02-12 08:22:13 | 2019-07-20 14:22:16 | 男   |
|  2 | 何青   |        1 | 1985-07-22 18:19:13 | 2019-07-17 21:50:38 | 女   |
|  3 | 钱佳   |        3 | 1989-11-17 10:29:13 | 2019-07-17 20:54:14 | 男   |
|  4 | 刘玉   |        1 | 1999-07-03 19:46:13 | 2019-07-17 20:54:14 | 女   |
|  5 | 后盾人 |        2 | 2003-09-01 20:33:13 | 2019-07-20 16:41:32 | 男   |
|  6 | 张云   |        3 | 1996-09-01 20:33:13 | 2019-07-19 12:59:40 | 女   |
|  7 | 李风   |        1 | 2003-02-15 20:33:13 | 2019-07-20 14:30:02 | 男   |
|  8 | 李兰   |        2 | NULL                | 2019-07-19 12:50:07 | 女   |
|  9 | 李月   |        1 | NULL                | 2019-07-18 17:49:03 | 女   |
| 10 | 刘雷   |     NULL | 1996-11-08 20:33:13 | 2019-07-20 15:59:28 | NULL |
+----+--------+----------+---------------------+---------------------+------+
10 rows in set (0.07 sec)

#复制表的数据结构
mysql> create table student like stu;
Query OK, 0 rows affected (0.60 sec)

mysql> select * from student
    -> ;
Empty set (0.00 sec)
#复制表的数据
mysql> insert into student select * from stu;
Query OK, 10 rows affected (0.17 sec)
Records: 10  Duplicates: 0  Warnings: 0

mysql> select * from student;
+----+--------+----------+---------------------+---------------------+------+
| id | sname  | class_id | birthday            | updated_at          | sex  |
+----+--------+----------+---------------------+---------------------+------+
|  1 | 李广   |        1 | 1998-02-12 08:22:13 | 2019-07-20 14:22:16 | 男   |
|  2 | 何青   |        1 | 1985-07-22 18:19:13 | 2019-07-17 21:50:38 | 女   |
|  3 | 钱佳   |        3 | 1989-11-17 10:29:13 | 2019-07-17 20:54:14 | 男   |
|  4 | 刘玉   |        1 | 1999-07-03 19:46:13 | 2019-07-17 20:54:14 | 女   |
|  5 | 后盾人 |        2 | 2003-09-01 20:33:13 | 2019-07-20 16:41:32 | 男   |
|  6 | 张云   |        3 | 1996-09-01 20:33:13 | 2019-07-19 12:59:40 | 女   |
|  7 | 李风   |        1 | 2003-02-15 20:33:13 | 2019-07-20 14:30:02 | 男   |
|  8 | 李兰   |        2 | NULL                | 2019-07-19 12:50:07 | 女   |
|  9 | 李月   |        1 | NULL                | 2019-07-18 17:49:03 | 女   |
| 10 | 刘雷   |     NULL | 1996-11-08 20:33:13 | 2019-07-20 15:59:28 | NULL |
+----+--------+----------+---------------------+---------------------+------+
10 rows in set (0.00 sec)

mysql>