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 vote224 views3 answers
Characters found after end of sql statement
SQL
1 vote166 views1 answer
Generate random data postgresql
SQL
0 vote165 views1 answer
Convert rows to columns in sql server
SQL
0 vote241 views1 answer
Mysql disable triggers
SQL
9 votes160 views3 answers
Where in sql
SQL
0 vote155 views1 answer
Oracle create package body
SQL
1 vote167 views1 answer
Mysql select utc time in eastern time
SQL
0 vote161 views1 answer
Mariadb number format
SQL
4 votes160 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote171 views3 answers
Sql server import json
SQL