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

3 votes126 views3 answers
Go variables
Go
0 vote135 views1 answer
Is the ninja airmouse good
Go
0 vote124 views1 answer
Script to download a file to google drive
Go
0 vote146 views4 answers
Buffered channels in golang
Go
1 vote115 views1 answer
Go execution duration
Go
1 vote71 views1 answer
Golang regex example
Go
0 vote119 views1 answer
Golang writefile example
Go
0 vote136 views1 answer
Golang read large file
Go
0 vote154 views1 answer
Ping and a public IP address such as Google’s public DNS server
Go
0 vote128 views1 answer
Flutter ListView goes infront of curved side Container
Go