创建备份表及修改表名:
CREATE table job_log_test like job_log;
RENAME TABLE job_log2 TO job_log_test;
创建备份表及导入数据
CREATE TABLE user_002 like user; # 1 创建表结构
INSERT into user_002 select * from user; # 2导入表数据
创建备份表及修改表名:
CREATE table job_log_test like job_log;
RENAME TABLE job_log2 TO job_log_test;
创建备份表及导入数据
CREATE TABLE user_002 like user; # 1 创建表结构
INSERT into user_002 select * from user; # 2导入表数据