Syntax error in MYSQl trigger creation

Question

Somewhere around here should be a syntax error, but I really can't find one:

DELIMITER |
CREATE TRIGGER Mieter_bi BEFORE INSERT ON Mieter FOR EACH ROW 
BEGIN 
 IF NEW.vorname = '' AND NEW.nachname = '' AND NEW.email = '' AND NEW.mieterID > 0
  THEN DELETE NEW;
 END IF;
END|

Error message:

#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 4

Thanks for helping ;)

juergen d · Accepted Answer · 2013-12-10 14:42:49Z

1

This is how you would cancel an insert

DELIMITER |
CREATE TRIGGER Mieter_bi BEFORE INSERT ON Mieter FOR EACH ROW 
BEGIN 
  IF NEW.vorname = '' AND NEW.nachname = '' AND NEW.email = '' AND NEW.mieterID > 0
  THEN 
    SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Any Message';
  END IF;
END|

edited Dec 10, 2013 at 14:42

answered Dec 10, 2013 at 14:18

juergen d

205k40 gold badges303 silver badges377 bronze badges

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

3 Comments

Zero9195 Over a year ago

I still get the same error message at the very same location. Thanks though. The syntax seems to be wrong, but I really can't figure out why...

Zero9195 Over a year ago

Still getting this syntax error. #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 7

Zero9195 Over a year ago

100% Sure. Anyway, it worked using phpmyadmin and using your code without Delimiter in the trigger tab. Thank you very much ;)

Collectives™ on Stack Overflow

Syntax error in MYSQl trigger creation

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