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 vote200 views1 answer
Alternative for LIMIT sql
SQL
0 vote185 views1 answer
Mysql wsrep ls
SQL
0 vote140 views1 answer
IIF
SQL
0 vote168 views1 answer
How to add mysql to path on termin after installation
SQL
3 votes152 views1 answer
Sql is not like
SQL
16 votes164 views1 answer
Mysql smallint range
SQL
0 vote153 views1 answer
Show table details postgresql
SQL
0 vote259 views1 answer
Python get backup of sql
SQL
0 vote163 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote144 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL