触发器内有多个插入/更新语句？

从文档： 创建触发器语法

trigger_stmt是触发触发器时要执行的语句。如果要执行多个语句，请使用BEGIN …
END复合语句构造。这也使您能够使用存储例程中允许的相同语句

CREATE TRIGGER testref BEFORE INSERT ON test1  FOR EACH ROW BEGIN    INSERT INTO test2 SET a2 = NEW.a1;    DELETe FROM test3 WHERe a3 = NEW.a1;    UPDATE test4 SET b4 = b4 + 1 WHERe a4 = NEW.a1;  END;