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

4 votes192 views2 answers
Postgresql reset sequence
SQL
-1 vote205 views3 answers
My sql alter table
SQL
0 vote187 views1 answer
Cara menampilkan user di mysql terminal
SQL
3 votes203 views4 answers
Mysql decimal
SQL
0 vote213 views2 answers
How to use aggregate functions in sql
SQL
0 vote207 views1 answer
Java sql connection
SQL
54 votes571 views6 answers
Sql rename column
SQL
0 vote174 views1 answer
Postgresql add leading zeros
SQL
0 vote216 views1 answer
Sql server convert to guid
SQL
0 vote205 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL