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

2 votes215 views1 answer
Sql find not in list
SQL
0 vote188 views1 answer
Execut sql python
SQL
0 vote252 views1 answer
Sql remove decimal places
SQL
0 vote185 views1 answer
Sqlite to csv statement
SQL
0 vote198 views1 answer
Sql last 7 days
SQL
0 vote206 views1 answer
Create mysql pool connection python flask
SQL
0 vote262 views1 answer
Sql track modification
SQL
104 votes1.1K views2 answers
Like in mysql
SQL
-1 vote198 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
1 vote222 views1 answer
Mysql remove last empty newline
SQL