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

4 votes144 views1 answer
Datepart postgres
SQL
0 vote154 views1 answer
Sql server size of every table in a db
SQL
0 vote139 views1 answer
Mysql table variables
SQL
50 votes211 views6 answers
Sql duplicate rows
SQL
8 votes136 views1 answer
How to remove tables from postgresql
SQL
0 vote153 views1 answer
Mysql date time string format for marshmellow field schema
SQL
4 votes148 views1 answer
Postgres delete last row
SQL
1 vote144 views1 answer
ALL_TAB_PARTITIONS
SQL
4 votes144 views2 answers
Sql server date now
SQL
0 vote141 views1 answer
Best way to bind parameters to SqlCommand C#
SQL