Application of timestamp type in MySQL

In the development process we generally need to remember the creation time of a record, in MySQL if you use the datetime type, cannot set the default value, we can use the timestamp type to record the creation time. But there's a problem with that, like your time just to record the creation time and not want to change as the record is updated (this can happen in terms of creation time), And this default timestamp to provide convenience is the time after the update changes, you can use the following statement to modify the field type, forcing it to update without changing.

ALTER TABLE ' tablename ' modify ' column ' timestamp not NULL DEFAULT current_timestamp;

Application of timestamp type in MySQL