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 vote256 views2 answers
Golang http testing
Go
-2 votes326 views1 answer
TypeError: search() got an unexpected keyword argument 'tld'
Go
0 vote281 views1 answer
How to block a rectangle from going off screen p5
Go
0 vote277 views2 answers
Icon material design google fonctionnemnt
Go
2 votes284 views1 answer
Golang read file line by line
Go
1 vote210 views2 answers
Golang waitgroup request
Go
2 votes254 views1 answer
Slick slider go to a particular slider
Go
0 vote266 views1 answer
Lambdas in golang
Go
0 vote285 views1 answer
Go create multiple variables on a single line
Go
0 vote253 views1 answer
"The most rapidly "blinking" pulsars are those that"
Go