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 vote168 views3 answers
Tushar Jadhav
Go
0 vote149 views1 answer
How to colorize the output of printf in golang
Go
59 votes284 views6 answers
Godot
Go
0 vote161 views1 answer
Go through synonym
Go
0 vote152 views1 answer
Escape html golang
Go
0 vote149 views1 answer
Why is my discord bot keep going offline
Go
0 vote145 views1 answer
Gracelful shutdown
Go
1 vote158 views1 answer
New golang
Go
0 vote98 views1 answer
Go convert a string (with decimals) to a floating point number.
Go
0 vote153 views1 answer
Aws s3 get file size
Go