mysql update on update current_timestamp code example
Example 1: mysql CURRENT_TIMESTAMP()
CURRENT_TIMESTAMP()
Example 2: mysql change timestamp on update
ALTER TABLE whatevertable
CHANGE whatevercolumn
whatevercolumn TIMESTAMP NOT NULL
DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP;