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

16 votes280 views4 answers
Mysql import from sql file
SQL
4 votes276 views1 answer
Oracle delete last row
SQL
0 vote280 views1 answer
How to change mysql port in xampp
SQL
0 vote329 views1 answer
Eliminate zero from integer mysql
SQL
1 vote508 views1 answer
Postgres convert text to number
SQL
1 vote301 views1 answer
Mysql return if it contains
SQL
0 vote284 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
1 vote288 views1 answer
Drop table if exists oracle
SQL
1 vote303 views1 answer
Sqlite update from another table
SQL
0 vote279 views1 answer
Mysql add to value
SQL