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 vote169 views1 answer
Split a string with expression and get the last value of split sql
SQL
27 votes198 views4 answers
Get all tables with column name sql
SQL
-1 vote202 views1 answer
Mysql change database charset and collation
SQL
4 votes198 views1 answer
Id primary key auto generated
SQL
0 vote193 views2 answers
Sql update top 100
SQL
0 vote194 views1 answer
Mysql check if lowercase
SQL
0 vote202 views1 answer
Sql on-premises
SQL
5 votes186 views1 answer
Oracle find foreign key dependencies
SQL
0 vote194 views1 answer
Sqlite get date only
SQL
0 vote200 views1 answer
Mysql last 6 months
SQL