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 vote408 views1 answer
Convert canvas to DataUrl and insert image in google sheet
Go
1 vote428 views1 answer
Golang wait for goroutine to finish
Go
1 vote423 views1 answer
Godot print
Go
0 vote426 views1 answer
Go program name
Go
0 vote514 views1 answer
How to execute linux command in golang
Go
0 vote471 views1 answer
Roblox lua how to make something go invisible
Go
0 vote476 views2 answers
Get date golang
Go
0 vote483 views1 answer
Golang check if ip is v6
Go
0 vote405 views1 answer
Correlation failed for google login
Go
0 vote438 views1 answer
Pymongo ping
Go