update xxx_infos set 字段1 = 1 where id in (select id from
(select distinct t.id from xxx_infos t where t.id not in (select m.id from yyy_infos m))v);
查询后更新字段 并去重
update xxx_infos set 字段1 = 1 where id in (select id from
(select distinct t.id from xxx_infos t where t.id not in (select m.id from yyy_infos m))v);
查询后更新字段 并去重