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 vote285 views2 answers
Sql searching via key word
SQL
6 votes286 views2 answers
Join vs union
SQL
4 votes317 views2 answers
Oracle drop job
SQL
8 votes345 views2 answers
Default sql server port
SQL
0 vote304 views1 answer
Postegresql update to null
SQL
0 vote284 views1 answer
Php delete database
SQL
1 vote320 views2 answers
Sql server backup table
SQL
0 vote299 views1 answer
What is between keyword used for
SQL
0 vote289 views1 answer
Contact mysql column field
SQL
0 vote297 views1 answer
How to read the potentail error messages in ssis package
SQL