problem while creating a trigger in mysql error 1064?

Question

I have a problem when creating trigger in mysql :

Error SQL query:

CREATE TRIGGER product_after_insert
AFTER INSERT
   ON FRUITS FOR EACH ROW

BEGIN
      INSERT INTO products
   ( category,
     product_id)
   VALUES
   ( 'fruit',
     New.ID)

MySQL said: Documentation 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 11

Possible duplicate of How can I fix MySQL error #1064?

Nick
– Nick

2018-11-17 12:02:33 +00:00
Commented Nov 17, 2018 at 12:02 — Nick
– Nick, Commented Nov 17, 2018 at 12:02

Madhur Bhaiya · Accepted Answer · 2018-11-17 11:31:45Z

2

Please find the fixed Trigger with inline comments about errors:

-- need to define DELIMITER to something else other than ;
DELIMITER $$

CREATE TRIGGER product_after_insert
AFTER INSERT
   ON FRUITS FOR EACH ROW

BEGIN
      INSERT INTO products
      (category,
       product_id)
      VALUES
      ('fruit',
        New.ID); -- ; was missing for statement execution

END $$  -- End the Begin clause

DELIMITER ;  -- Redefine the delimiter back to ;

answered Nov 17, 2018 at 11:31

Madhur Bhaiya

28.9k10 gold badges53 silver badges61 bronze badges

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

Collectives™ on Stack Overflow

problem while creating a trigger in mysql error 1064?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related