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

3 votes194 views1 answer
Compile go code
Go
0 vote187 views1 answer
Using either macro within goto sugarcube
Go
1 vote194 views3 answers
Answers of google forms in inspect element
Go
0 vote139 views1 answer
Kubernetes field selector
Go
0 vote183 views1 answer
Golang read rune from file
Go
1 vote199 views1 answer
Embedded mongodb gradle maven dependency
Go
6 votes204 views1 answer
Go map check key exists
Go
6 votes196 views1 answer
Golang map has key
Go
0 vote198 views1 answer
Download file in go
Go
0 vote201 views1 answer
Golang convert rune to string
Go