mysql 循环查询依赖_如何避免MySQL中的循环触发器依赖

尝试使用变量.

第一次触发：

CREATE TRIGGER trigger1

BEFORE DELETE

ON table1

FOR EACH ROW

BEGIN

IF @deleting IS NULL THEN

SET @deleting = 1;

DELETE FROM table2 WHERE id = OLD.id;

SET @deleting = NULL;

END IF;

END

第二次触发：

CREATE TRIGGER trigger2

BEFORE DELETE

ON table2

FOR EACH ROW

BEGIN

IF @deleting IS NULL THEN

SET @deleting = 1;

DELETE FROM table1 WHERE id = OLD.id;

SET @deleting = NULL;

END IF;

END

额外的AFTER DELETE触发器：

CREATE TRIGGER trigger3

AFTER DELETE

ON table1

FOR EACH ROW

BEGIN

SET @deleting = NULL;

END

CREATE TRIGGER trigger4

AFTER DELETE

ON table2

FOR EACH ROW

BEGIN

SET @deleting = NULL;

END