业务场景 去除B表中重复A 表的数据
A 表设置如下触发器
B表插入A表 新增的不重复的数据
begin
DECLARE number int;
SET number=(select count(1) from tb_program_member where face_match=1 and person_id=new. cardid);
if(number=0) then
insert into tb_program_member ( person_name, person_id,sex,img_url,face_match)
values(new.name,new.cardid,new.gender,new.photopath,new.FaceMatch);
end if;
end