尝试使用变量。
第一次触发：
CREATE TRIGGER trigger1 BEFORE DELETe ON table1 FOR EACH ROWBEGIN 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 ROWBEGIN 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 ROWBEGIN SET @deleting = NULL;ENDCREATE TRIGGER trigger4 AFTER DELETE ON table2 FOR EACH ROWBEGIN SET @deleting = NULL;END
