Answers for "mysql datetime default on update"

set default today mysql

ALTER TABLE table
ADD column DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;

Posted by: Guest on April-08-2021

mysql modify default value

ALTER TABLE tbl_name ALTER column_name SET DEFAULT new_value;

Posted by: Guest on July-20-2021

Code answers related to "mysql datetime default on update"