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

11 votes438 views2 answers
Golang read file
Go
0 vote373 views10 answers
Golang round float to number of digits
Go
3 votes379 views3 answers
What is google
Go
3 votes376 views1 answer
Google translate english to korean
Go
0 vote424 views1 answer
Case in golang
Go
0 vote405 views1 answer
Visual studio code go
Go
0 vote367 views1 answer
Zoom map to city with city name google map developer
Go
0 vote415 views1 answer
The action run applescript encountered an error : "finder got an error: you don't have permission to create a file here
Go
0 vote439 views2 answers
Multiple return types in golang
Go
5 votes412 views2 answers
Minecraft logo png
Go