ALTER TABLE t1
MODIFY COLUMN c1
TIMESTAMP
NULL -- the opposite is NOT NULL, which is implicitly set on timestamp columns
DEFAULT NULL -- no default value for newly-inserted rows
ON UPDATE CURRENT_TIMESTAMP;
0
solved How can I add “ON UPDATE CURRENT_TIMESTAMP” on a column at table creation or by alter table withoud defining its default value