Best to read about Triggers before trying to write one, eg an Update Trigger can't issue an Update on the table for which it's defined, it has to use SET syntax. But why didn't you just default the timestamp column with ON UPDATE TIMESTAMP?