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

7 votes244 views1 answer
Module.exports = router;
Go
5 votes243 views2 answers
Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.6.1:compile (default-compile) on project a2: Compilation failure [ERROR] No compiler is provided in this environment. Perhaps you are running on a JRE rather than a JDK?
Go
0 vote224 views1 answer
Golang http save downloaded file
Go
0 vote222 views1 answer
Bool to string golang
Go
0 vote231 views1 answer
How to copy external files with code godot
Go
1 vote256 views2 answers
How to diagnose horizontal scroll that will not go away on mobile site
Go
0 vote252 views1 answer
Append two arrays golang
Go
0 vote234 views1 answer
Golang bufio gjson
Go
0 vote251 views1 answer
Go lang interation stack overflow
Go
0 vote226 views1 answer
I got a really nice cable and a set of keycaps more mthis keyboard, sssssssdasdfasddddxx bbbsdfbsdfbsdfbsdf
Go