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 vote296 views1 answer
List MySQL Table and Index Size
SQL
0 vote315 views1 answer
Mysql loop through databases and execute query
SQL
5 votes284 views2 answers
Mysql where in array
SQL
0 vote331 views2 answers
Sql having multiple conditions
SQL
2 votes339 views3 answers
Mysql kill
SQL
2 votes345 views2 answers
Mysql bidirectional composite primary key
SQL
11 votes315 views3 answers
Change column name sql server management studio
SQL
0 vote300 views2 answers
Sql server select where date
SQL
0 vote323 views1 answer
Pgsql is not permitted to log in
SQL
0 vote324 views1 answer
Typeorm raw sql
SQL