MySQL 触发器导致错误 #1064

Question

我尝试在 MySQL 中编写这个小触发器，

CREATE TRIGGER `leg` BEFORE INSERT ON `bckoff` 
FOR EACH ROW BEGIN
 INSERT INTO `bckoff` SET `step`=1;
END;

之后我收到此错误..我是 MySQL 的新手..所以请在这里帮助我..

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 

Answer 1

即使修复了此错误 - 您还会遇到另一个错误：您无法修改创建触发器的表。

顺便说一句，这就是您应该如何创建此触发器：

delimiter |

CREATE TRIGGER `leg` BEFORE INSERT ON `bckoff` 
FOR EACH ROW BEGIN
 INSERT INTO `bckoff` SET `step`=1;
END;
|

delimiter ;