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

1 vote302 views2 answers
Mysql between
SQL
0 vote308 views1 answer
Vowels in sql
SQL
17 votes296 views3 answers
How to change a collumn name in sql
SQL
0 vote316 views1 answer
Sql server information_schema temp tables
SQL
0 vote323 views1 answer
Sqlite insert or update
SQL
6 votes319 views2 answers
How to get yesterday date in mysql
SQL
22 votes300 views4 answers
Mysql reset auto increment id
SQL
0 vote330 views1 answer
Cahnge column name apex oracle
SQL
2 votes304 views1 answer
Postgresql left join distinct on
SQL
0 vote313 views1 answer
Connecting mySQL to STS
SQL