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:00 冻奶香甜玉米片 阅读(2247) 评论(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不允许的
不可以把触发条件和触发动作归于一表
