先做一些约定,原库名为B1,备份库名为B2,表名为T,表主键为A
1、先将要备份的内容放入备份库,
2、delete from B1..T where A in (select A from B2..T);
还原时:
insert into B1..T select * from B2..T where A not in (select A from B1..T);
1、先将要备份的内容放入备份库,
2、delete from B1..T where A in (select A from B2..T);
还原时:
insert into B1..T select * from B2..T where A not in (select A from B1..T);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货