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

2 votes281 views1 answer
Show max_allowed_packet mysql
SQL
1 vote264 views1 answer
Mysql tables max count
SQL
0 vote261 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote295 views1 answer
How to make sure two tables have same exact data in sql
SQL
1 vote251 views1 answer
Column with prefix in sql
SQL
3 votes254 views3 answers
Mysql get table size
SQL
3 votes262 views1 answer
Sql server check version
SQL
0 vote286 views1 answer
Vs 2019 connect to local mysql database
SQL
1 vote279 views1 answer
Sql select whole row max column
SQL
0 vote328 views1 answer
Drop table BigQuery table columns
SQL