Unable to create this MYSQL Trigger on PHPMYADMIN

Question

I am trying to update a column ( called DateModified ) before update happens on the table row.

so here is my trigger:

CREATE TRIGGER `date_mod_category` BEFORE UPDATE ON `categories`
 FOR EACH ROW BEGIN
    SET new.DateModified = NOW();
END

BUT I GET THIS DAMN ERROR WHICH I JUST CANNOT FIGURE OUT WHY:

Since there is only 1 statement in the trigger you don't need BEGIN..END — P.Salmon, Aug 02 '20 at 07:43

score 0 · Accepted Answer · answered Aug 02 '20 at 07:23

0

Use DELIMITER

DELIMITER //
CREATE TRIGGER `date_mod_category` BEFORE UPDATE ON `categories`
 FOR EACH ROW 
 BEGIN
   SET new.DateModified = NOW();
 END //
 DELIMITER ;

answered Aug 02 '20 at 07:23

Majid Hajibaba

2,834
6
19
46

can you explain why this is required? – Biswas Khayargoli Aug 02 '20 at 10:06
Your welcome @BiswasKhayargoli , please read this answer to find your answer: https://stackoverflow.com/a/10259528 – Majid Hajibaba Aug 02 '20 at 10:09

Unable to create this MYSQL Trigger on PHPMYADMIN

1 Answers1