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 views1 answer
How to go back to the same page in data table after refreshing
Go
0 vote197 views1 answer
Pymongo timeout
Go
4 votes206 views1 answer
Ubuntu mongodb db list
Go
1 vote213 views1 answer
Time now golang int64
Go
0 vote208 views1 answer
Go remove pacakge
Go
1 vote238 views1 answer
I got guns in my head and they won't go
Go
3 votes218 views1 answer
What is google translate
Go
0 vote220 views1 answer
Golang palindrome
Go
0 vote235 views1 answer
How to block a rectangle from going off screen p5
Go
0 vote219 views1 answer
Iterate over iterator golang
Go