MySQL--备份表操作，简单易懂！_mysql创建备份表

原理：将一个查询结果当做一张表进行新建！

以此完成表的快速复制

表创建出来的同时，表中的数据也有了

mysql> select * from s_user;
+------+----------+------------+---------------------+
| id   | name     | birth      | create_time         |
+------+----------+------------+---------------------+
|    1 | zhangsan | 1990-10-01 | 2023-09-29 23:41:55 |
|    2 | w1       | 1990-10-02 | 2023-10-05 23:46:08 |
|    3 | w2       | 1990-10-03 | 2023-10-05 23:46:08 |
|    4 | w3       | 1990-10-04 | 2023-10-05 23:46:08 |
+------+----------+------------+---------------------+
4 rows in set (0.01 sec)
 
mysql> create table s_user2 as select * from s_user;
Query OK, 4 rows affected (0.01 sec)
Records: 4  Duplicates: 0  Warnings: 0
 
mysql> select * from s_user2;
+------+----------+------------+---------------------+
| id   | name     | birth      | create_time         |
+------+----------+------------+---------------------+
|    1 | zhangsan | 1990-10-01 | 2023-09-29 23:41:55 |
|    2 | w1       | 1990-10-02 | 2023-10-05 23:46:08 |
|    3 | w2       | 1990-10-03 | 2023-10-05 23:46:08 |
|    4 | w3       | 1990-10-04 | 2023-10-05 23:46:08 |
+------+----------+------------+---------------------+
4 rows in set (0.00 sec)