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 vote179 views1 answer
Delete from IN subquery
SQL
0 vote120 views1 answer
Postgresql where clause not working
SQL
1 vote119 views1 answer
Oracle check table space
SQL
3 votes127 views3 answers
Remove all spaces from string sql
SQL
0 vote122 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote138 views1 answer
Hotw to alter lengh character vayng postgres
SQL
1 vote134 views1 answer
Sql server insert into temp table
SQL
0 vote126 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
15 votes117 views2 answers
Install mysql 8 ubuntu 18.04
SQL
0 vote130 views1 answer
Sql decode
SQL