insert ignore Into 可以过滤表的索引唯一值 这个比较常用
NOT EXISTS 对比两表不同的字段 有点类似于子查询 not In
例子
insert into T_Table1(id,agencyid,supplierid,productagencyid,CreationTime)(
SELECT * FROM ( select UUID() ,a.AgencyId,a.supplierid,a.id as productagencyid,a.CreationTime from t_product_productagency_copy1 a
where a.IsDeleted=0 and a.AgencyId='3a03a4a5-a8be-bbc8-bad5-eeefc345fb5c' AND a.supplierid IS NOT NULL AND a.ProductionPlace='HPD'
) m
WHERE NOT EXISTS (
SELECT * FROM T_Table2 b WHERE m.productagencyid= b.productagencyid AND m.supplierid =b.supplierid
)
)