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

5 votes179 views4 answers
Mysql on duplicate key update
SQL
-1 vote187 views1 answer
Get month and year from date in mysql sequelize
SQL
6 votes130 views5 answers
Alter table oracle
SQL
10 votes152 views2 answers
What is database
SQL
11 votes132 views5 answers
Laravel db facade
SQL
34 votes131 views6 answers
Sql change data type
SQL
4 votes154 views2 answers
Tables in sql
SQL
3 votes149 views1 answer
Oracle cannot access v$session
SQL
13 votes280 views4 answers
Sql joining 3 tables
SQL
0 vote92 views1 answer
Sql truncate table referencing itself
SQL