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 vote132 views1 answer
Upload to shared folder google drive cli linu
Go
0 vote164 views1 answer
Axes not compatible with matplotlib pdf
Go
0 vote126 views1 answer
Go count distinct elements in list
Go
0 vote141 views1 answer
Clear trash ubuntu
Go
6 votes133 views1 answer
How to check if a value exists in map golang
Go
19 votes272 views6 answers
Mongo delete all documents
Go
2 votes136 views1 answer
Do animals go to heaven
Go
2 votes138 views2 answers
Vue js 3.0 installation in ubuntu
Go
3 votes146 views3 answers
What is the test case
Go
0 vote161 views1 answer
Named return values in golang
Go