Mysql on update current_timestamp

Press CTRL+C to copy CREATE TABLE t1 (
  ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  dt DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

Source: dev.mysql.com

Mysql change timestamp on update

ALTER TABLE whatevertable
     CHANGE whatevercolumn 
            whatevercolumn TIMESTAMP NOT NULL
                           DEFAULT CURRENT_TIMESTAMP 
                           ON UPDATE CURRENT_TIMESTAMP;

Source: stackoverflow.com

Similar codes

1 vote238 views1 answer
Mysql select update same table
SQL
3 votes170 views1 answer
Postgresql where current year
SQL
16 votes213 views3 answers
T-SQL Add Column
SQL
0 vote268 views1 answer
Get first monday of month sql
SQL
0 vote142 views1 answer
FindAllBy
SQL
0 vote187 views1 answer
IIF
SQL
23 votes213 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote267 views1 answer
Manage Database in MySQL
SQL
3 votes216 views1 answer
Oracle function return
SQL
3 votes157 views1 answer
Ubuntu install postgresql 12
SQL