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

0 vote271 views1 answer
Mysql check datetime equals date
SQL
11 votes296 views2 answers
Oracle saurce code
SQL
1 vote248 views1 answer
Foreign key constraint in ms sql
SQL
15 votes269 views2 answers
Install mysql 8 ubuntu 18.04
SQL
0 vote281 views1 answer
Stored function in sql
SQL
4 votes281 views6 answers
Second max salary in sql
SQL
0 vote268 views2 answers
Create sequence if not exists postgres
SQL
3 votes266 views1 answer
Sql timestamp to date
SQL
2 votes287 views3 answers
Sql interview query questions
SQL
1 vote279 views1 answer
Spring postgresql reset auto increment to 0
SQL