首页 > 其他 > 详细

Can’t update table ‘xxx’ in stored function/trigger because it is already used by statement which invoked this stored function/trigger

时间:2018-09-02 19:52:34      阅读:380      评论:0      收藏:0      [点我收藏+]

MySQL: Solution for ERROR 1442 (HY000): Can’t update table ‘xxx’ in stored function/trigger because it is already used by statement which invoked this stored function/trigger.

今天在做触发器时发生了这个错误

原因是在对某表操作时同时触发对该表插入

估计这在mysql不允许的

不可以把触发条件和触发动作归于一表

Can’t update table ‘xxx’ in stored function/trigger because it is already used by statement which invoked this stored function/trigger

原文:https://www.cnblogs.com/FlFtFw/p/9574780.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!