Sql auto update dupdated_at

ALTER TABLE t1
ADD COLUMN created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
ADD COLUMN updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;

Source: stackoverflow.com

Sql auto update dupdated_at

CREATE TABLE t1 (
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

Source: stackoverflow.com

Similar codes

1 vote166 views1 answer
How not to sort by average rating
SQL
11 votes155 views2 answers
Mysql disable safe mode
SQL
0 vote166 views1 answer
Sql insert query list of dictionaries
SQL
-1 vote160 views1 answer
How to Activate the database
SQL
0 vote145 views1 answer
Oracle enable chain
SQL
0 vote146 views1 answer
Mysql Like(searching in the string)
SQL
6 votes142 views2 answers
Mysql first day of month
SQL
0 vote139 views1 answer
Gcloud check sql
SQL
1 vote141 views1 answer
MySQL AND Operator
SQL
2 votes150 views2 answers
Postgres add column integer
SQL