mysql 触发器错误 Can't update table in stored function/trigger because it is already used by state(已解决)
错误
Can’t update table ‘’ in stored function/trigger because it is already used by statement
产生原因
- 原因一:
触发器中使用了insert语句
示例表结构
定义一个插入触发器,new代表插入进来的值,new.sex则说明插进来的sex
插入触发器定义成功
执行插入语句
报错 1442 - Can’t update table ‘reader’ in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
- 原因二
触发器中使用了update语句
先删掉之前定义的触发器
定义一个新的插入触发器
执行插入语句
报错 1442 - Can’t update table ‘reader’ in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
解决方法
触发器中使用set,不要用insert和update
删掉之前的触发器,并重新定义一个插入触发器
使用的是set
执行插入语句,插入成功