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 vote338 views1 answer
Where field is null sql knex
SQL
0 vote338 views1 answer
Migrations.RunSQL
SQL
0 vote319 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
1 vote380 views1 answer
Postgresql if 0 then 1
SQL
0 vote284 views1 answer
Flask_sqlalchemy install
SQL
1 vote283 views1 answer
Restart identity postgresql
SQL
36 votes344 views3 answers
Finding duplicate column values in table with sql
SQL
7 votes323 views4 answers
Database dump mysql command
SQL
0 vote324 views1 answer
How to check default value of column in sql server
SQL
0 vote417 views1 answer
Mysql show schema
SQL