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 vote188 views1 answer
Enable Rabbitmq management plugin
SQL
0 vote194 views1 answer
Narural join
SQL
1 vote295 views1 answer
SQL server query column yes or no
SQL
35 votes201 views6 answers
Postgres
SQL
0 vote187 views2 answers
Sql update top 100
SQL
0 vote194 views1 answer
Ajouter une clé etrangere mysql
SQL
0 vote185 views1 answer
Sqlite referential integrity
SQL
1 vote269 views1 answer
Oracle create program if not exists
SQL
0 vote174 views1 answer
Mysql select statement after index
SQL
0 vote198 views1 answer
What is database username and password in mysqliconnect
SQL