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

5 votes114 views4 answers
Mysql update column with value from another table
SQL
1 vote105 views2 answers
T sql get foreign key
SQL
0 vote129 views1 answer
SQLServerException.makeFromDatabaseError
SQL
4 votes109 views1 answer
Mysql set max connections
SQL
3 votes118 views1 answer
How to find names includes in sql
SQL
1 vote109 views1 answer
Sql server 2012 query history
SQL
1 vote136 views1 answer
Mysql dump specific tables
SQL
0 vote116 views1 answer
Oracle archivelog usage
SQL
0 vote119 views1 answer
Sql server concat null
SQL
59 votes288 views6 answers
Alter table sql
SQL