insert into "SR"(sid, rid,is_parse)
select * from
(
SELECT s.id as sid, r.id as rid,0 FROM "Segment" s ,"Rule" r where s.domain=r.domain order by sid,rid
) srall
where not exists (
select 1 from "SR" sr where sr.sid=srall.sid and sr.rid=srall.rid
)
集合差
最新推荐文章于 2022-04-24 06:30:00 发布