7,712
社区成员
发帖
与我相关
我的任务
分享
insert into a select * from b where id not in (select id from a);
insert into b select * from a where id not in (select id from b);
update a inner join b on a.id=b.id
set a.col=b.col
where a.col is null
update a inner join b on a.id=b.id
set b.col=a.col
where b.col is null