建立一个inser触发器

Question

功能：

d表有属性（d_id,s_num,sum）,yao表有属性（id,price,count）（注：d_id跟ID一样）

当我向d表添加：insert  into d(s_id,num)  values ( '01',6)时，更改yao表中count=count-5，d表的s_sum=price*num,

我的代码为：

delimiter $

create trigger tg1 after insert on d for each row 

begin

update yao,d set count=count-new.num,d_sum=new.num*sprice where id=new.d_id;

end$

delimiter;

结果显示：

Can't update table 'd' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.

求大神帮我写个，或者改下

Answer 1

换个名字试试