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 vote127 views1 answer
Mysql login console
SQL
0 vote138 views1 answer
Kill slow queries mysql
SQL
2 votes125 views1 answer
Update with join sql server
SQL
0 vote157 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
0 vote146 views1 answer
Is not numeric sql
SQL
9 votes137 views5 answers
Sql limit
SQL
1 vote125 views1 answer
Postgres grant read only access to database
SQL
2 votes139 views1 answer
Sqlite insert if not exists
SQL
2 votes133 views1 answer
Update trigger
SQL
0 vote151 views1 answer
Snowflake drop column
SQL