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

4 votes168 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
2 votes223 views3 answers
Mysql unix timestamp to date
SQL
0 vote170 views1 answer
Count characters of string mysql
SQL
0 vote193 views1 answer
Sql datum formatieren
SQL
24 votes160 views2 answers
Alter table delete column
SQL
2 votes173 views2 answers
How to check data type in sql server
SQL
0 vote175 views1 answer
Postgres full text search example
SQL
0 vote177 views1 answer
Stored function in sql
SQL
18 votes155 views4 answers
Foreign key mySql
SQL
8 votes168 views1 answer
Oracle find text in functions
SQL