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 vote311 views1 answer
Go make string from char array
Go
5 votes352 views2 answers
Csgo mouse wheel jump bind
Go
0 vote365 views2 answers
Link for a search result from google
Go
6 votes354 views1 answer
Go map check key exists
Go
3 votes375 views1 answer
The gold standard
Go
2 votes324 views1 answer
How to create custom google home commands
Go
0 vote357 views1 answer
Golang iterate reverse slice
Go
1 vote355 views1 answer
Pandas go through csv file
Go
1 vote369 views1 answer
Anaconda google colab
Go
0 vote342 views1 answer
Golang get request data
Go