Mysql syntax error in delete trigger

Question

Could anyone tell me that what is the syntax error in this trigger

DELIMITER |

CREATE TRIGGER User_XEntity_Before_Delete

BEFORE DELETE

   ON UserXEntity FOR EACH ROW

BEGIN

   -- Insert record into Delete_UserXEntity table
   INSERT INTO Delete_UserXEntity
   ( DeletedUserXEntityId,
     UserId,
     CreatedAt)
   VALUES
   ( OLD.Id,
     OLD.UserId,
     NOW() );

END;

|

DELIMITER ;

Trigger looks good, are you adding it on mysql terminal or some other client like phpmyadmin ? — Abhik Chakraborty
– Abhik Chakraborty, Commented Dec 4, 2014 at 6:32

Manish Jangir · Accepted Answer · 2014-12-04 06:34:25Z

1

I've got the solution. Actually I was entering this code in phpmyadmin Trigger window, where it asks about table name, time and event already. So we only need to write the trigger action code in that window. I was writing the whole trigger code and that's why I was giving me a syntax error.

We only need to write the following code in PHPMYADMIN add new trigger windows:

INSERT INTO Delete_UserXEntity
   ( DeletedUserXEntityId,
     UserId,
     CreatedAt)
   VALUES
   ( OLD.Id,
     OLD.UserId,
     NOW() );

answered Dec 4, 2014 at 6:34

Manish Jangir

5,4576 gold badges49 silver badges79 bronze badges

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

Collectives™ on Stack Overflow

Mysql syntax error in delete trigger

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related