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

10 votes228 views2 answers
Linux command line import mysql database
SQL
13 votes223 views4 answers
Mysql get last row
SQL
0 vote268 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
2 votes228 views2 answers
Mysql on duplicate key ignore
SQL
0 vote229 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
1 vote245 views1 answer
What is a Database?
SQL
0 vote227 views1 answer
Learn sqlite dart
SQL
0 vote227 views2 answers
Tsql row number
SQL
12 votes228 views2 answers
Delete entries in postgresql
SQL
0 vote236 views1 answer
Oracle query archive mode
SQL