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

14 votes251 views2 answers
Install mysqldump
SQL
0 vote241 views1 answer
Azure sql server check foreign key
SQL
0 vote243 views1 answer
Sql delete caracter list
SQL
0 vote219 views1 answer
Increment id in mysql
SQL
0 vote237 views1 answer
Alter table add foreign key mariadb example
SQL
3 votes225 views1 answer
Mysql set field unique
SQL
0 vote232 views1 answer
Mysql date time string format python
SQL
4 votes250 views1 answer
Mysql delete last row
SQL
1 vote246 views1 answer
Sql server list locks
SQL
0 vote235 views1 answer
Sql insert from excel
SQL