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

2 votes150 views2 answers
Mysql get last character of string
SQL
0 vote204 views1 answer
Sql query contains multiple ids
SQL
12 votes219 views1 answer
Env var for setting password for root user mysql docker hub
SQL
4 votes282 views4 answers
Update select mysql
SQL
0 vote201 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
15 votes269 views4 answers
Export mysql db using command line
SQL
0 vote202 views1 answer
Get cpu details sql
SQL
8 votes223 views1 answer
Mysql restore database
SQL
0 vote189 views1 answer
Select from column mysql
SQL
0 vote315 views1 answer
Sql insert exemplo
SQL