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

2 votes303 views3 answers
Sql server: how to concatenate column data using comma
SQL
5 votes271 views2 answers
Update all rows mysql
SQL
0 vote289 views1 answer
Mysql undo delete
SQL
0 vote306 views1 answer
Nodejs sql get one to many relationship as array
SQL
0 vote291 views1 answer
Window function to forward fill
SQL
0 vote301 views2 answers
Mysql on update current_timestamp
SQL
3 votes296 views1 answer
Sql online test questions and answers
SQL
0 vote287 views1 answer
Selecting Data in SQL - Select Data
SQL
0 vote278 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
8 votes286 views1 answer
Alter tablespace add datafile autoextend
SQL