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

1 vote351 views1 answer
Library google chart
Go
0 vote327 views1 answer
Created_at timestamp sql query
Go
1 vote371 views1 answer
Go append array to array
Go
0 vote354 views1 answer
Recenter google map based on route
Go
0 vote492 views1 answer
Golang maximum length for numbers
Go
0 vote390 views1 answer
Golang read response body
Go
0 vote381 views1 answer
Golang Excel
Go
0 vote394 views2 answers
Get date golang
Go
0 vote365 views1 answer
How to make history super interesting
Go
0 vote313 views1 answer
Check if gorm created successfully
Go