MySQL 'Update Timestamp' Column - Trigger
Don't know if it'll work for you, but you can always make it a TIMESTAMP
field with no default value -- MySQL will automatically set the value of the first such field defined in the table to the current timestamp on every update.
If the field can be defined as a timestamp, you can use the following:
ts2 TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
Okay, try this one:
DELIMITER $$ CREATE
TRIGGER `cams`.`tsu_update_csi` BEFORE UPDATE
ON `cams`.`csi`
FOR EACH ROW BEGIN
SET NEW.tsu = CURRENT_TIMESTAMP;
END$$ DELIMITER ;