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 vote414 views1 answer
Go comparison
Go
0 vote541 views1 answer
Golang maximum length for numbers
Go
0 vote349 views2 answers
Go slices
Go
3 votes386 views1 answer
Loop list golang
Go
0 vote418 views1 answer
.setColumnWidths() google script
Go
-1 vote422 views1 answer
Imorting font style from google
Go
7 votes439 views1 answer
Module.exports = router;
Go
4 votes459 views4 answers
Is Grepper good?
Go
3 votes384 views1 answer
Emacs go to line
Go
0 vote477 views2 answers
How to parse io.nopCloser golang
Go