Re: Before Update Trigger prevents further edit in MySQL 8.0

[David Harrison]

Hi Peter. I found a better way to populate the Updated column using DDL ON UPDATE syntax.

However, I decided to try a different trigger to see if the behavior persisted. It did. Here is the new trigger:

CREATE DEFINER = CURRENT_USER TRIGGER `idojo`.`Action_AFTER_INSERT` AFTER INSERT ON `Action` FOR EACH ROW
BEGIN
UPDATE Senshu S
SET S.PointTot = S.PointTot + 1
WHERE S.ID = NEW.SenshuID;
END

This trigger actually worked and updated the column in the Senshu table. However, when I try to edit the Action table I get the error messages described earlier.

Thank you.