syntax to use near '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;