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 votes170 views1 answer
Oracle failed login attempts
SQL
0 vote181 views1 answer
How to Remove milliseconds from Date time
SQL
-1 vote129 views1 answer
Mysql how to set update or create
SQL
0 vote179 views1 answer
Recently updated stored procedure in sql server
SQL
5 votes193 views2 answers
Mysql dump mysql db cli
SQL
0 vote181 views1 answer
Load data from text file to mysql database on mac terminal
SQL
1 vote191 views1 answer
Print year of a date sql
SQL
0 vote199 views1 answer
Updating database in sql
SQL
0 vote179 views1 answer
Openquery insert into linked server
SQL
0 vote181 views1 answer
How to create a new db from dumb file mysql
SQL