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 vote148 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote141 views1 answer
Mysql select last 15 minutes
SQL
-1 vote154 views2 answers
Import data from excel to sql server automatically
SQL
0 vote154 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
0 vote137 views1 answer
Select from column mysql
SQL
0 vote248 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
1 vote148 views1 answer
Mysql f# examples
SQL
0 vote144 views2 answers
SQL Server Standard
SQL
0 vote138 views1 answer
Mariadb number format
SQL
0 vote145 views1 answer
Mariadb cast null to 0
SQL