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

1 vote146 views1 answer
Golang http set user agent header
Go
5 votes117 views1 answer
Inline array golang
Go
2 votes133 views1 answer
Do animals go to heaven
Go
0 vote174 views1 answer
Join slice to string golang
Go
0 vote148 views7 answers
If conditional golang
Go
1 vote124 views1 answer
I cant see script editor google sheet
Go
2 votes133 views3 answers
Type switch golang
Go
0 vote136 views2 answers
Go get items in a list
Go
0 vote137 views1 answer
How much google pays to software engineer
Go
3 votes137 views2 answers
Delete all pods in default namespace
Go