Mysql快速备份sql
1.备份表结构和数据(先完整备份表结构,再插入数据)
create table 新表 like 需要备份的表;
insert into 新表 (select * from 需要备份的表);
例如:
create table hcm_worker_employment_b3 like hcm_worker_employment;
insert into hcm_worker_employment_b3 (select * from hcm_worker_employment);