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

16 votes351 views2 answers
Oracle ddl
SQL
17 votes364 views4 answers
Postgres list users
SQL
0 vote375 views1 answer
Count columns psql(PostreSQL)
SQL
5 votes327 views1 answer
Mysql select greater than yesterday
SQL
0 vote382 views1 answer
Postgres list users and roles
SQL
0 vote433 views1 answer
Select new table sql
SQL
2 votes351 views1 answer
Oracle calculated column
SQL
3 votes332 views1 answer
Oracle limit user tablespace
SQL
0 vote389 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote314 views1 answer
Import sql mysql ubuntu
SQL