Answers for "sql auto update dupdated_at"

SQL
0

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;
Posted by: Guest on May-28-2021
0

sql auto update dupdated_at

CREATE TABLE t1 (
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);
Posted by: Guest on May-23-2021

Code answers related to "sql auto update dupdated_at"

Code answers related to "SQL"

Browse Popular Code Answers by Language