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 vote118 views1 answer
Projection on image from camera in godot
Go
0 vote110 views1 answer
How much google pays to software engineer
Go
0 vote99 views1 answer
Golang convert from ISO 8601 to milliseconds
Go
3 votes102 views2 answers
Go convert float to a string
Go
0 vote110 views1 answer
Give a cell a bottom border google script
Go
0 vote98 views1 answer
Run go code
Go
0 vote182 views1 answer
Duolingo test format
Go
8 votes179 views4 answers
Golang []byte to string
Go
0 vote99 views1 answer
Custom echo golang middleware
Go
0 vote110 views2 answers
Gorm enum
Go