34,838
社区成员




insert b select * from a except select * from b
insert b select * from A except select * from b
insert B select * from A where not exists(select 1 from B where a.x=b.x)
insert B select * from A where not exists(select 1 from B where a.x=b.x)
insert b select a.* from a left join b on a.key=b.key where b.key is null
trucate table b
insert into b
select * fro a