mysql触发器问题

[挨踢直男]

我在一个表上创建一个insert触发器， 这个触发器用于修改表自身上某个字段的值， 这样是不是不可以?或者有什么办法解决

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

[wwwwb]

你的代码？不能对本表进行操作

[挨踢直男]

引用 1 楼 wwwwb 的回复:

你的代码？不能对本表进行操作

 drop trigger if EXISTS  t_goods_insert; 
 create  trigger t_goods_insert  before insert on goods
 FOR EACH ROW
 BEGIN
 	 update goods 
 		 set zhekou = if( new.promotions_price, new.promotions_price / new.price, 1 )
 		 where goods_id = new.goods_id;
 END

这个样子

[wwwwb]

drop trigger if EXISTS t_goods_insert; create trigger t_goods_insert before insert on goods FOR EACH ROW BEGIN set new.zhekou = if( new.promotions_price, new.promotions_price / new.price, 1 ); END

[挨踢直男]

引用 3 楼 wwwwb 的回复:

drop trigger if EXISTS t_goods_insert; create trigger t_goods_insert before insert on goods FOR EACH ROW BEGIN set new.zhekou = if( new.promotions_price, new.promotions_price / new.price, 1 ); END

顺便问一下， mysql能不能触发器类型同时是 insert,update的

[wwwwb]

不能，分别写

[ACMAIN_CHM]

MYSQL的触发器必须各写各的，无法合并。