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 vote232 views1 answer
Create table like sql
SQL
21 votes201 views3 answers
Sql average
SQL
0 vote216 views1 answer
Sql decimal to 2 places
SQL
0 vote233 views1 answer
Bitmap join index
SQL
0 vote187 views1 answer
Sql right characters
SQL
0 vote209 views1 answer
Mysql calculated column
SQL
1 vote195 views1 answer
Autocommit mysql
SQL
0 vote215 views1 answer
Mysql terminal run sql file
SQL
0 vote211 views1 answer
Oracle current timestamp
SQL
0 vote195 views1 answer
Postgresql find missing id
SQL