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 vote111 views1 answer
Check sql database table lock
SQL
6 votes115 views3 answers
How to delete table sqlite
SQL
0 vote120 views1 answer
Mysql date time string format for marshmellow field schema
SQL
1 vote116 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote115 views1 answer
Postgres statistics
SQL
0 vote123 views1 answer
How to display value of variable in mysql
SQL
1 vote118 views1 answer
Mysql size int
SQL
0 vote119 views1 answer
What is delimiter in mysql
SQL
1 vote116 views1 answer
Sql pick random row
SQL
18 votes116 views6 answers
Laravel form validation
SQL