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 vote142 views1 answer
Golang len return type
Go
1 vote132 views1 answer
Include relation in mongo query
Go
3 votes175 views1 answer
How to exclude keywords google
Go
0 vote153 views1 answer
Go ipfs
Go
7 votes145 views2 answers
What is go
Go
0 vote197 views1 answer
Go count occurrences of a substring
Go
1 vote207 views1 answer
Kubernetes get pod crash logs
Go
1 vote142 views1 answer
Pandas go through csv file
Go
0 vote136 views1 answer
Using either macro within goto sugarcube
Go
0 vote134 views1 answer
How to add extension logo of chrome
Go