MySQL触发器更新本表数据异常:Can’t update table ‘tbl’ in stored function/trigger because it is already used by statement which invoked this
092172

如果你在触发器里面对刚刚插入的数据进行了 insert/update, 则出现这个问题。因为会造成循环的调用.

create trigger test
before update on test
for each row
update test set NEW.updateTime = NOW() where id=NEW.ID;
END
create trigger test
before update on test
for each row
update test set NEW.updateTime = NOW() where id=NEW.ID;
END
create trigger test
before update on test
for each row
update test set NEW.updateTime = NOW() where id=NEW.ID;
END

 

应该使用set操作，而不是在触发器里使用 update,比如

create trigger test
before update on test
for each row
set NEW.updateTime = NOW();
END
create trigger test
before update on test
for each row
set NEW.updateTime = NOW();
END
create trigger test
before update on test
for each row
set NEW.updateTime = NOW();
END

 

© 版权声明

本站部分内容来自网络转载，由Alive整理后呈现，版权归原作者所有，如果有侵犯到您的权益，请联系本站删除，谢谢合作！
THE END
数据库
# mysql# 触发器
喜欢就支持以下吧
点赞2打赏一下
分享
面对困难的时候，要勇敢、执着、不畏艰辛地去战胜它
In the face of difficulties, be brave, persistent and tirelessly to overcome it
相关推荐

标签

Alipay (1) Array (2) cookie (1) git (1) JavaScript (2) js (1) mysql (2) PHP (4) redis (1) Wechat (1) 前端 (1) 字符串 (1) 截屏 (1) 接码 (1) 数据库 (1) 短信 (1) 触发器 (1) 调用摄像头 (1) 谷歌浏览器 (1) 锁 (1) 高并发 (1)

友情链接