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 vote429 views1 answer
Mysql convert charset
SQL
0 vote364 views1 answer
Group by two columns postgres
SQL
2 votes341 views1 answer
Apex execute batch job
SQL
0 vote344 views1 answer
Find all tables where column name exists oracle
SQL
0 vote379 views2 answers
Script all indexes in a database
SQL
0 vote369 views3 answers
How to run sql query
SQL
0 vote338 views1 answer
Update set with inner join oracle
SQL
1 vote354 views1 answer
Postgres set column equal to another
SQL
0 vote352 views1 answer
Android sqlite get rows count
SQL
8 votes393 views2 answers
Mysql grant all privileges to user from any host
SQL