新建触发器
DELIMITER ||
DROP TRIGGER IF EXISTS inventory_tig||
CREATE TRIGGER inventory_tig AFTER UPDATE ON pt_sessions_level FOR EACH ROW
BEGIN
IF new.inventory = 0 THEN
UPDATE
pt_sessions_level
SET
STATUS = 0
WHERE inventory = 0;
END IF;
END||
当我执行update语句时
UPDATE
pt_sessions_level
SET
inventory = 0
WHERE sessionslevelid = 683
会报Can't update table 'pt_sessions_level' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
异常。哪位大神解决下