我在一个表上创建一个insert触发器, 这个触发器用于修改表自身上某个字段的值, 这样是不是不可以?或者有什么办法解决//报错
Can't update table 'table_name' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
Can't update table 'table_name' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
解决方案 »
- 1135Can't create a new thread (errno 12)
- mysqld 问题。。
- insert语句,不知道错在哪里
- 请问我用phpMyAdmin 2.6.2在数据库中插入中文有乱码,怎么解决?
- 怎样将远端的mysql数据库备份到本地,用C#实现,给个思路吧!
- 菜鸟求救!在线等!mysql启动有问题!
- 请教:我刚开始接触mysql,我看初始情况下表user字段Host有值为"%",这代表什么意思
- 百分请教:### 通过PHP连接MySQL失败 ###
- mysql安装问题
- 请问大家关于MySql数据备份的问题???(解决给分)
- mysql操作时出现的问题
- MySqlTransaction中的commit(),如果服务器中断未执行到这步,数据会提交吗?
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
这个样子
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的