1.备份表结构:



create table 新表名 as select * from 旧表名 where 1=2; 
例如: create table mdm_gw_codebak20210922 as select * from mdm_gw_code where 1=2;



2.备份表数据:


insert into 新表名 select * from 旧表名; 
例如: insert into mdm_gw_codebak20210922 select * from mdm_gw_code;