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

3 votes202 views2 answers
How to delete git repo locally
SQL
27 votes207 views3 answers
Mysql show tables in database
SQL
1 vote194 views1 answer
Oracle insert multiple rows into same table
SQL
0 vote163 views1 answer
Materialized view redshift
SQL
2 votes178 views1 answer
Sql as
SQL
-1 vote197 views1 answer
Ms sql select datetime as date
SQL
1 vote182 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
13 votes169 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote196 views1 answer
View psql output in horizontal scrolling
SQL
1 vote174 views1 answer
Psql autocomplete for mac brew install
SQL