56,679
社区成员
发帖
与我相关
我的任务
分享
insert into shizi_certificate_member (uid, columnid)
SELECT view_aaa.uid, class2 FROM view_aaa
WHERE NOT EXISTS(
select 1 from shizi_certificate_member, view_aaa
WHERE view_aaa.uid = shizi_certificate_member.uid
and view_aaa.class2 = shizi_certificate_member.columnid )
INSERT INTO B
SELECT * ,
0
FROM A
WHERE NOT EXISTS ( SELECT *
FROM B
WHERE A.id = B.id
AND B.class = A.class );
SELECT * FROM B