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

2 votes160 views1 answer
Mysql create user with remote access
SQL
0 vote99 views1 answer
MySQL error code 2068
SQL
0 vote120 views1 answer
Sql decimal to 2 places
SQL
5 votes94 views1 answer
Mysql get last day of month
SQL
1 vote100 views1 answer
User privileges postgresql information_schema
SQL
0 vote153 views1 answer
Sql int vs integer
SQL
13 votes134 views4 answers
Mysql remove foreign key constraint
SQL
0 vote108 views1 answer
Laravel eloquent get generated sql
SQL
13 votes107 views2 answers
Sql join
SQL
0 vote137 views1 answer
Sqlite schema structure of a relational database
SQL