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 vote166 views1 answer
On delete set default
SQL
0 vote185 views1 answer
Get initials name in sql
SQL
0 vote145 views1 answer
Postgresql parse json array
SQL
0 vote164 views1 answer
Mysql add text to existing field
SQL
0 vote135 views1 answer
Oracle list chain steps
SQL
5 votes144 views1 answer
Oracle scan source ddl
SQL
1 vote169 views2 answers
Sql where is not number
SQL
0 vote106 views1 answer
Check sql query executed wp
SQL
1 vote189 views1 answer
Base64 encode sql server
SQL
0 vote137 views1 answer
Mysql update sequence with order by
SQL