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

6 votes314 views2 answers
Mysql first day of month
SQL
0 vote341 views1 answer
How to insert multiple values in a single column in sql
SQL
11 votes340 views1 answer
Oracle view source
SQL
0 vote334 views1 answer
Connect by query in oracle
SQL
0 vote323 views1 answer
Show database not empty tables postgres
SQL
4 votes316 views2 answers
What is table in sql
SQL
0 vote313 views1 answer
Porcentaje sql
SQL
6 votes314 views2 answers
Mysql check auto increment value
SQL
1 vote322 views2 answers
List tables sqlalchemy
SQL
0 vote329 views1 answer
Power bi find all ids not in other tables
SQL