mysql触发器语句错误，不知道错在哪里 5
DELIMITER$createtriggersage_constraintbeforeinsertons_rz0136foreachrowbeginifnew.sage...
DELIMITER $
create trigger sage_constraint
before insert on s_rz0136 for each row
begin
if new.sage < 8 or new.sage > 45
then ;
end if;
end$
DELIMITER ;
错误：
Error Code: 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 '; end if; end' at line 5 展开
create trigger sage_constraint
before insert on s_rz0136 for each row
begin
if new.sage < 8 or new.sage > 45
then ;
end if;
end$
DELIMITER ;
错误：
Error Code: 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 '; end if; end' at line 5 展开
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
