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 ;