创建触发器报错“已经存在相同的事件触发”
有一个存储过程和一个触发器,通过触发器调用存储过程:
create procedure abc(tid int,tname varchar(20))
returning int;
define i int;
let i=10;
let tid=tid+i;
insert into zzz(id,name) values(tid,tname);
return 1;
end procedure;
create trigger tzz
insert on zz
referencing new as n
for each row
(
execute procedure abc(n.id,n.name)
);