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

1 vote225 views2 answers
How to search date in sql query
SQL
2 votes210 views1 answer
Sqlite insert if not exists
SQL
0 vote212 views1 answer
Remove binlog mysql
SQL
3 votes282 views1 answer
Mysql cli connect with password
SQL
15 votes226 views4 answers
Create table if not exists sql
SQL
2 votes215 views2 answers
Useradd postgres
SQL
0 vote246 views1 answer
Python mysql check if database exists
SQL
1 vote214 views2 answers
Change table name phpmyadmin
SQL
0 vote210 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote218 views2 answers
Postgres default user
SQL