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 vote164 views1 answer
Go convert binary data into ASCII text using Base64 RFC 4648.
Go
0 vote167 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 vote164 views1 answer
Go select timeout
Go
0 vote159 views2 answers
Go goose
Go
2 votes110 views1 answer
Google translate english to spanish
Go
-1 vote157 views1 answer
Strings in golang
Go
3 votes188 views1 answer
The gold standard
Go
0 vote166 views1 answer
Union in go
Go
1 vote165 views1 answer
How-to-prevent-google-colab-from-disconnecting
Go
3 votes166 views1 answer
What is google translate
Go