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 vote297 views1 answer
Bag of gold
Go
2 votes311 views1 answer
Do animals go to heaven
Go
1 vote313 views3 answers
Set cell value google script
Go
0 vote325 views1 answer
Golang how to print message
Go
0 vote316 views4 answers
Go composite type data
Go
253 votes443 views6 answers
Gme stocks
Go
0 vote307 views2 answers
Run go file
Go
0 vote286 views1 answer
Struct is not nil golang
Go
0 vote295 views1 answer
Golang make chan
Go
0 vote377 views1 answer
Duolingo test format
Go