Answers for "mysql date is updated"

SQL
0

created at and updated at in mysql

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
1

on update date mysql

ALTER TABLE t1 MODIFY post_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
Posted by: Guest on April-26-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language