表中有一个字段为LEVEL,类型为INT,我写了个UPDATE 触发器,如果这个LEVEL字段被修改成0了,然后删除该记录,为什么一直报ERROR:1442,Can’t update table ‘t1′ in stored function/trigger because it is already used by statement which invoked this stored function/trigger.这个错误,求帮助。。
触发器是这么写的
IF NEW.LEVEL = 0 THEN
DELETE FROM TB WHERE ID = NEW.ID;
END IF;
触发器是这么写的
IF NEW.LEVEL = 0 THEN
DELETE FROM TB WHERE ID = NEW.ID;
END IF;
在MYSQL TRIGGER中,不能对本表进行操作