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 vote160 views1 answer
Drop all procedures sql server
SQL
0 vote151 views1 answer
Postgresql delete multiple rows
SQL
0 vote188 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
3 votes152 views2 answers
Brew start mysql
SQL
0 vote163 views2 answers
Close external port 3306 with iptables
SQL
0 vote156 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
0 vote155 views1 answer
Min salary in sql
SQL
1 vote252 views1 answer
Truncate table in postgresql and reset id
SQL
3 votes169 views1 answer
Oracle user quota on tablespace
SQL
1 vote150 views2 answers
Sql for date greater than
SQL