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

28 votes137 views6 answers
Mysql change user password
SQL
3 votes145 views5 answers
No module named 'MySQLdb'
SQL
0 vote137 views1 answer
Mysql to get column name in database
SQL
1 vote159 views1 answer
Oracle plan hash value
SQL
0 vote229 views1 answer
Run mysql xampp shell
SQL
1 vote143 views1 answer
Oracle sql average
SQL
1 vote138 views1 answer
Table information in sql server
SQL
0 vote131 views1 answer
Postgresql where clause not working
SQL
2 votes140 views1 answer
Pdo mysql insert
SQL
1 vote138 views1 answer
Postgresql substring last
SQL