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

2 votes185 views4 answers
Duplicate record mysql
SQL
3 votes200 views3 answers
Stop mysql service ubuntu
SQL
0 vote199 views1 answer
MySQL error code 2068
SQL
1 vote204 views2 answers
Setval max id postgresql sequence
SQL
3 votes138 views2 answers
Mysql sum with condition
SQL
0 vote197 views1 answer
How to get specific salary in sql
SQL
0 vote194 views1 answer
How to generate ids in sql
SQL
1 vote196 views2 answers
Postgres cast as decimal
SQL
5 votes202 views2 answers
To date oracle
SQL
2 votes201 views2 answers
Postgres add column integer
SQL