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 vote246 views1 answer
Sql show custom constraints
SQL
0 vote220 views7 answers
10 random questions use python and SQL
SQL
0 vote233 views1 answer
What is top n result in sql
SQL
0 vote227 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
1 vote191 views2 answers
Show sql logs in spring boot
SQL
2 votes232 views1 answer
Mysql clear screen
SQL
1 vote224 views2 answers
Datetrunc hour snowflake
SQL
0 vote255 views1 answer
Stored procedure function relation
SQL
0 vote244 views1 answer
Kill slow queries mysql
SQL
11 votes242 views2 answers
You are using safe update mode
SQL