I want to make a trigger to record the time of any update as
CREATE TRIGGER col_update AFTER UPDATE ON col FOR EACH ROW BEGIN UPDATE col SET updated=NOW() WHERE id=NEW.id; // or OLD.id END
The problem is that when this
trigger tries to UPDATE the
updated column, it is also another UPDATE event which runs the
trigger. This will create an infinite loop, which does not work.
How can I restore the update time in the corresponding column?
NOTE: I wish to use trigger, as there are many columns in the table. If I try to set the update time manually, I need to modify many queries.