Mysql 同步增量数据

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
)
)