Modify Table - zhamri/MyClass-MySQL GitHub Wiki

Add a New date_update Column:

ALTER TABLE `test_student`
ADD `date_update` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;

Modify the Existing date_create Column:

ALTER TABLE `test_student`
MODIFY `date_create` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;