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 vote107 views1 answer
Golang scan directory
Go
0 vote128 views1 answer
Googe drive mount google colab
Go
0 vote114 views1 answer
Golang string uppercase
Go
1 vote114 views1 answer
Golang backward loop
Go
2 votes114 views1 answer
Bcrypt golang
Go
1 vote105 views2 answers
Go
Go
1 vote120 views1 answer
Embedded mongodb gradle maven dependency
Go
0 vote108 views1 answer
How to make sure that google colab runtime is not expired
Go
-1 vote114 views1 answer
Go functions
Go
0 vote116 views1 answer
Run a go app
Go