Answers for "how to set on update current timestamp in mysql"

mysql CURRENT_TIMESTAMP()

CURRENT_TIMESTAMP()

mysql change timestamp on update

ALTER TABLE whatevertable
     CHANGE whatevercolumn 
            whatevercolumn TIMESTAMP NOT NULL
                           DEFAULT CURRENT_TIMESTAMP 
                           ON UPDATE CURRENT_TIMESTAMP;