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 vote315 views1 answer
Add text with marker google map android
Go
2 votes330 views1 answer
Golang get string length
Go
2 votes324 views1 answer
Go declarations
Go
0 vote352 views1 answer
Golang crash course
Go
22 votes440 views1 answer
Drop mongo database
Go
11 votes381 views3 answers
Golang string includes
Go
0 vote331 views1 answer
Djnago HistoricalRecords
Go
1 vote340 views1 answer
What makes a good website
Go
4 votes355 views1 answer
GoMint server host
Go
0 vote322 views1 answer
Download quiz template in google forms
Go