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 vote300 views1 answer
Go make string from char array
Go
213 votes474 views6 answers
Gamestop stocks
Go
1 vote334 views1 answer
Csgo max ping
Go
0 vote318 views1 answer
List of keywords in golang
Go
0 vote339 views1 answer
Overwrite file
Go
3 votes323 views1 answer
Emacs go to line
Go
0 vote351 views1 answer
Typeorm load 5 item of relations
Go
0 vote357 views3 answers
Go replace string
Go
0 vote326 views1 answer
Sum by name in google sheets
Go
0 vote327 views1 answer
Golang switch no condition
Go