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

2 votes224 views2 answers
Uint64 to byte golang
Go
1 vote200 views3 answers
For loop in golang
Go
0 vote203 views1 answer
Go type conversion
Go
5 votes231 views2 answers
Minecraft logo transparent
Go
0 vote206 views2 answers
Icon material design google fonctionnemnt
Go
1 vote208 views1 answer
Consta t golang
Go
0 vote205 views1 answer
Jogo entre ladroes streaming movie
Go
0 vote208 views1 answer
Go change json key struct
Go
0 vote216 views1 answer
Go create multiple variables on a single line
Go
0 vote207 views1 answer
How to print string in golang
Go