Answers for "mysql timestamp update automatically"

SQL
1

mysql create timestamp column

ALTER TABLE `table1` ADD `lastUpdated` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ;
Posted by: Guest on September-24-2020
0

mysql change timestamp on update

ALTER TABLE whatevertable
     CHANGE whatevercolumn 
            whatevercolumn TIMESTAMP NOT NULL
                           DEFAULT CURRENT_TIMESTAMP 
                           ON UPDATE CURRENT_TIMESTAMP;
Posted by: Guest on September-14-2020

Code answers related to "mysql timestamp update automatically"

Code answers related to "SQL"

Browse Popular Code Answers by Language