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

1 vote171 views1 answer
Give a column name to values generated from case statement in sql
SQL
0 vote175 views1 answer
Implicit inner join table alias with id values
SQL
1 vote230 views1 answer
Psql connect
SQL
0 vote168 views1 answer
Like sql for second letter of the family name
SQL
0 vote164 views1 answer
Acutal month year
SQL
0 vote171 views7 answers
Les jointures sql server
SQL
1 vote242 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote196 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote174 views1 answer
Postgresql update to unique
SQL
1 vote173 views1 answer
Sql server datetime vs datetime2
SQL