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

0 vote227 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote231 views1 answer
Database db connection string format
SQL
0 vote214 views1 answer
How to get one year old query from plan cache
SQL
0 vote216 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote185 views5 answers
Sql table intermédiaire
SQL
0 vote212 views1 answer
Sp in sql server
SQL
23 votes248 views6 answers
Create table sql
SQL
0 vote228 views1 answer
Sqlcmd no headers
SQL
1 vote151 views1 answer
Mssql string length
SQL
0 vote204 views1 answer
Sql string length postgresql
SQL