在另一个触发器中启用和禁用触发器

-- 禁用触发器
ALTER TABLE TableName DISABLE TRIGGER TriggerName;

-- 启用触发器
ALTER TABLE TableName ENABLE TRIGGER TriggerName;

CREATE TRIGGER trg_EnableDisableTrigger
ON TableName
AFTER INSERT
AS
BEGIN
    IF (/* 某些条件 */)
    BEGIN
        ALTER TABLE TableName DISABLE TRIGGER TriggerName;
    END
    ELSE
    BEGIN
        ALTER TABLE TableName ENABLE TRIGGER TriggerName;
    END
END;

-- 禁用触发
ALTER TABLE TableName DISABLE TRIGGER TriggerName;

-- 启用触发
ALTER TABLE TableName ENABLE TRIGGER TriggerName;

DELIMITER $$

CREATE TRIGGER trg_EnableDisableTrigger
AFTER INSERT ON TableName
FOR EACH ROW
BEGIN
    IF (/* 某些条件 */) THEN
        ALTER TABLE TableName DISABLE TRIGGER TriggerName;
    ELSE
        ALTER TABLE TableName ENABLE TRIGGER TriggerName;
    END IF;
END$$

DELIMITER ;

-- 禁用触发器
ALTER TRIGGER TriggerName DISABLE;

-- 启用触发器
ALTER TRIGGER TriggerName ENABLE;

CREATE OR REPLACE TRIGGER trg_EnableDisableTrigger
AFTER INSERT ON TableName
FOR EACH ROW
BEGIN
    IF (/* 某些条件 */) THEN
        EXECUTE IMMEDIATE 'ALTER TRIGGER TriggerName DISABLE';
    ELSE
        EXECUTE IMMEDIATE 'ALTER TRIGGER TriggerName ENABLE';
    END IF;
END;