Answer the question
In order to leave comments, you need to log in
I made a trigger, but it does not work, how to fix it?
I made this kind of trigger:
CREATE TRIGGER bonus
AFTER INSERT ON `personal` FOR EACH ROW
UPDATE personal SET cash = 10000 + NEW.cash;
Operation failed: There was an error while applying the SQL script to the database.
ERROR 1442: 1442: Can't update table 'personal' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question