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 vote154 views1 answer
Golang jwt
Go
12 votes284 views5 answers
Convert string to int golang
Go
0 vote155 views3 answers
Golang 2 dimensional array
Go
2 votes158 views1 answer
Is minecraft good
Go
0 vote147 views1 answer
Multipe diference suite ginkgo
Go
0 vote148 views1 answer
When do we need & in golang
Go
0 vote157 views1 answer
This release is not compliant with the Google Play 64-bit requirement The following APKs or App Bundles are available to 64-bit devices, but they only have 32-bit native code: 3. site:stackoverflow.com
Go
0 vote154 views1 answer
Gospider
Go
1 vote163 views2 answers
How to diagnose horizontal scroll that will not go away on mobile site
Go
0 vote149 views1 answer
Golang square
Go