SQL syntax error in mysql when creating trigger

Question

I have a problem when creating a trigger in mysql i get this 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

This is my first time creating triggers for mysql help

Here is the code:

        CREATE TRIGGER insertAfterUser AFTER INSERT ON MEMBERS    
        FOR EACH ROW    
        BEGIN    
        INSERT INTO blagajna (MemberId,StanjeRacuna) VALUES(12,0.0);    
        END;

vaso123 · Accepted Answer · 2014-12-09 12:44:40Z

1

You need to set the delimiter

delimiter //
CREATE TRIGGER insertAfterUser AFTER INSERT ON MEMBERS    
      FOR EACH ROW    
      BEGIN    
      INSERT INTO blagajna (MemberId,StanjeRacuna) VALUES(12,0.0);    
      END;//
delimiter ;

answered Dec 9, 2014 at 12:44

vaso123

12.4k4 gold badges37 silver badges68 bronze badges

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

Comments

Sharma Vikram · Accepted Answer · 2014-12-09 12:48:53Z

1

CREATE TRIGGER `insertAfterUser ` BEFORE INSERT ON `members` FOR EACH ROW BEGIN INSERT INTO   blagajna (MemberId,StanjeRacuna) VALUES('12','0.0'); END;

edited Dec 9, 2014 at 12:48

answered Dec 9, 2014 at 12:41

Sharma Vikram

2,4846 gold badges26 silver badges48 bronze badges

Collectives™ on Stack Overflow

SQL syntax error in mysql when creating trigger

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related