1442-Can’t update table ‘XXX’ in stored function/trigger because it is already used by statement whi

wdzsjl 7个月前 (02-21) 阅读数 124 #数据库

文章标签数据库

错误记录：

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

错误原因：

解决方案：

MySQL中触发器中不能对本表进行 insert ,update ,delete操作，以免递归循环触发。对于update 只能用set进行操作，insert与delete只能借助第二张表才能实现需求。

上一篇：1064-You have an error in your SQL syntax; check the manual that corresponds to your MySQL server ve 下一篇：There is no such grant defined for user '%s' on host '%s'