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 vote129 views2 answers
Golang sort struct
Go
0 vote151 views1 answer
Golang maximum length for numbers
Go
0 vote136 views1 answer
Instancing in godot
Go
1 vote197 views1 answer
Kubernetes get pod crash logs
Go
0 vote117 views2 answers
Google chrome path in mac
Go
0 vote140 views1 answer
Projection on image from camera in godot
Go
0 vote126 views2 answers
Golang http testing
Go
-2 votes164 views1 answer
TypeError: search() got an unexpected keyword argument 'tld'
Go
1 vote127 views1 answer
How to make things invisible in godot
Go
8 votes216 views4 answers
Golang byte to string
Go