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 vote278 views3 answers
Set cell value google script
Go
0 vote288 views2 answers
Golang udp server example
Go
0 vote268 views2 answers
Int32 vs int64
Go
4 votes260 views2 answers
Appending map into map golang
Go
2 votes277 views2 answers
Golang interface
Go
0 vote260 views1 answer
Golang mongo create index
Go
2 votes267 views1 answer
Reverse a string in golang
Go
1 vote259 views1 answer
Golang remove last item from slice
Go
0 vote251 views1 answer
Golang set env var
Go
0 vote303 views2 answers
Display logo in material ui
Go