发布网友
共2个回答
热心网友
最简单的同步
delete from b
insert into b select * from a
或者
insert into b
select *
from a where not exists (select 1 from b where uid = a.uid)
热心网友
用MERGE