为啥一直提示这错误mysql

Question

————————————前面已建触发器——————————————mysql> create trigger upd_check before update on tb    -> for each row    -> begin    -> if new.a < 0 then    -> set new.a =0;    -> elseif new.a > 100 then    -> set new.a = 100;    -> end if ;    -> end ; //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 '-> for each row    -> begin    -> if new.a < 0 then    -> set new.a =0; ' at line 2

Answer 1

分隔符