如:
create table t001 as select * from TB where 条件1;
create table t002 as select * from TB where 条件2;
create table t003 as select * from TB where 条件3;
...
然后再插入表中另一表备份中(bak)
insert into bak select * from t001;
insert into bak select * from t001;
insert into bak select * from t001;
...