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 vote278 views1 answer
Show mysql account privilleges
SQL
4 votes181 views4 answers
Date less than in sql
SQL
0 vote215 views2 answers
Oracle ora-00054 how to unlock
SQL
0 vote196 views1 answer
Mysql get first 2 characters of string
SQL
1 vote237 views2 answers
Laravel jwt generate token
SQL
2 votes174 views1 answer
Create table with primary key
SQL
9 votes246 views3 answers
Postgres make sql dump
SQL
0 vote189 views1 answer
Initcap in mysql
SQL
7 votes194 views1 answer
Sql server management studio turn on line numbers
SQL
0 vote218 views1 answer
Delete a temporary table mysql
SQL