没测试 1 insert into person2(name,sex,pid) select name,sex,group_concat(id) from person1 group by name,sex; 2 create trigger tri_test after insert on person1 for each row begin if exists(select 1 from person2 where name=old.name and sex=old.sex) update person2 set pid=concat(pid,old.id) where name=old.name and sex=old.sex; else insert into person2((name,sex,pid) values(old.name,old.sex,old.id); end if end
1
insert into person2(name,sex,pid)
select name,sex,group_concat(id) from person1 group by name,sex;
2
create trigger tri_test after insert on person1 for each row
begin
if exists(select 1 from person2 where name=old.name and sex=old.sex)
update person2 set pid=concat(pid,old.id) where name=old.name and sex=old.sex;
else
insert into person2((name,sex,pid) values(old.name,old.sex,old.id);
end if
end
没有遍历条件 就是发送一个sql语句 语句怎么执行同用不用存储过程没有关系的~~~