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 votes241 views1 answer
Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.20.1:test (default-test) on project upload
Go
251 votes333 views6 answers
Live stock price gme
Go
0 vote228 views1 answer
Golang writefile example
Go
0 vote268 views4 answers
Golang round float to number of ditigs precision
Go
0 vote250 views1 answer
Salutem ex gonsas
Go
0 vote234 views1 answer
Why was dual government abolished in bengal
Go
1 vote240 views3 answers
For loop golang
Go
1 vote304 views1 answer
Kubernetes get pod crash logs
Go
0 vote255 views1 answer
Golang send email jordan-wright
Go
-1 vote235 views1 answer
String array to string golang
Go