Syntax error when trying to create a BEFORE INSERT trigger

Asked Oct 12 '21 at 08:09

Active Oct 12 '21 at 08:09

Viewed 25 times

CREATE TRIGGER age_trigger BEFORE INSERT ON kids FOR EACH ROW 
BEGIN 
IF (NEW.age < 0) THEN SET NEW.age = NEW.age * -1;
END IF;
END;

I am getting an error:

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 5

I have tried removing the if/else, hardcoding NEW.AGE = 50, and looked at examples online. My syntax matches online examples, but I keep getting the same error. I don't believe its my version of MySQL. Thoughts?

edited Oct 12 '21 at 08:09

jarlh

42,561
8
45
63

asked Oct 12 '21 at 08:09

webdesignnoob

2

Apart from `DELIMITER // ` `.... //` `DELIMITER ;` it looks fine to my inexperienced eyes. – Joop Eggen Oct 12 '21 at 08:17
@JoopEggen Ah, I missed that! It works now, thank you so much! – webdesignnoob Oct 12 '21 at 08:28

Syntax error when trying to create a BEFORE INSERT trigger

0 Answers0