22,209
社区成员
发帖
与我相关
我的任务
分享
insert into a(id,qq,标记) select id,qq,'1' from b where not exists(select 1 from a where qq=b.qq)
insert a(id,qq,标记)\
select id,qq,标记='1'
from b
where not exists (
select 1 from a
where qq = b.qq
)
insert into A
select a.*,'标记' from B a left join A b on a.QQ=b.QQ
where a.QQ is null
INSERT INTO A
SELECT ID,QQ
FROM B
WHERE NOT EXISTS(
SELECT 1 FROM A WHERE A.QQ=B.QQ
)
insert into A
select a.*,'标记' from B a left join A b on a.QQ=b.QQ and a.QQ is null