mysql tigger语法范例

DROP TRIGGER IF EXISTS ins_sum;

-- 单行
CREATE TRIGGER ins_sum BEFORE INSERT ON account FOR EACH ROW SET @sum = @sum + NEW.amount;

-- 多行
DELIMITER //
CREATE TRIGGER ins_sum BEFORE INSERT ON account
FOR EACH ROW
BEGIN
    SET @sum = @sum + NEW.amount;
END;//
DELIMITER ;