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

9 votes159 views5 answers
Laravel to sql
SQL
1 vote201 views1 answer
Size of all tables in a schema oracle
SQL
0 vote156 views1 answer
Oracle show grants on table
SQL
3 votes141 views2 answers
Sql asc
SQL
1 vote160 views1 answer
Mysql curdate between two dates
SQL
1 vote145 views1 answer
Oracle get current schema
SQL
7 votes139 views1 answer
Sql server convert string to date
SQL
0 vote142 views2 answers
How to check if sqlite table exists in nodejs
SQL
1 vote184 views1 answer
Postgresql if 0 then 1
SQL
1 vote149 views1 answer
Search for replace in mysql
SQL