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 vote109 views1 answer
Can we rollback in sql
SQL
0 vote130 views1 answer
What is common table expression in sql
SQL
0 vote140 views1 answer
Mysql error codeigniter
SQL
1 vote157 views1 answer
How to select department from table
SQL
0 vote104 views1 answer
Mysql undo delete
SQL
0 vote99 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote131 views1 answer
Mysql join only one column
SQL
0 vote73 views1 answer
Hangfire clean script
SQL
1 vote99 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
3 votes120 views1 answer
Oracle undo tablespace schema
SQL