MySQL Error on Before Trigger for END IF Statement

Question

Hello I am trying to write a trigger in mysql and below is my code`

DELIMITER $$
CREATE TRIGGER updateNewEmp
BEFORE INSERT ON employess
FOR EACH ROW
BEGIN
    IF new.salary <50000 THEN
    SIGNAL SQLSTATE '45000'
    END IF
END$$
DELIMITER ;

But I get an error stating #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'END IF END' at line 7. Could someone please explain what am I doing wrong here?

You need a semicolon at the end of the SIGNAL statement.

Bill Karwin
– Bill Karwin

2017-10-30 16:27:36 +00:00
Commented Oct 30, 2017 at 16:27 — Bill Karwin
– Bill Karwin, Commented Oct 30, 2017 at 16:27
I did that too and it says unexpected token ; near

bhuvanesh arasu
– bhuvanesh arasu

2017-10-30 16:29:29 +00:00
Commented Oct 30, 2017 at 16:29 — bhuvanesh arasu
– bhuvanesh arasu, Commented Oct 30, 2017 at 16:29
You really have a table named "employess"?

n8.
– n8.

2017-10-30 16:30:49 +00:00
Commented Oct 30, 2017 at 16:30 — n8.
– n8., Commented Oct 30, 2017 at 16:30
Yes I have a table named employess

bhuvanesh arasu
– bhuvanesh arasu

2017-10-30 16:48:23 +00:00
Commented Oct 30, 2017 at 16:48 — bhuvanesh arasu
– bhuvanesh arasu, Commented Oct 30, 2017 at 16:48

Gordon Linoff · Accepted Answer · 2017-10-30 16:29:28Z

4

Try putting semicolons in:

DELIMITER $$
CREATE TRIGGER updateNewEmp
BEFORE INSERT ON employess
FOR EACH ROW
BEGIN
    IF new.salary <50000 THEN
        SIGNAL SQLSTATE '45000';
    END IF;
END$$

DELIMITER ;

answered Oct 30, 2017 at 16:29

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

bhuvanesh arasu Over a year ago

Thanks for the comment.That does not work either. It still gives me unexpected token ; near . Pic: tinypic.com/r/oab1fs/9

Gordon Linoff Over a year ago

@bhuvanesharasu . . . Are you using a rather archaic version of MySQL?

bhuvanesh arasu Over a year ago

I am using phpmyadmin. But when I used MySQL workbench this worked. I then figured out that there is something wrong with the phpmyadmin version. Thank you! It worked :)

Collectives™ on Stack Overflow

MySQL Error on Before Trigger for END IF Statement

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related