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 vote229 views1 answer
Oracle sql copy table without data
SQL
-1 vote224 views1 answer
Get id from just inserted row mysql server python
SQL
1 vote198 views1 answer
MySQL AND Operator
SQL
4 votes223 views4 answers
Rollback in sql
SQL
0 vote352 views1 answer
Sql change a colum to unique
SQL
11 votes599 views4 answers
Reset identity column values in sql server
SQL
0 vote198 views1 answer
Count column of tables psql
SQL
0 vote217 views1 answer
Mysql select where field like in list
SQL
0 vote228 views2 answers
Advantages of stored procedures sql
SQL
6 votes211 views2 answers
Insert into select mysql
SQL