[Solved] How can I add “ON UPDATE CURRENT_TIMESTAMP” on a column at table creation or by alter table withoud defining its default value


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