Current_timestamp and on UPDATE current_timestamp differences in MySQL database

, in the MySQL database, when the field type is TIMESTAMP, if the default value is Current_timestamp, when you insert a record, the value of End_time is automatically set to the current time of the system, if the on UPDATE is checked Current_ TIMESTAMP, the Time field is updated in real time with the update command, that is, End_time automatically updates to the latest time when the primary key primary key of the datasheet changes.

If Current_timestamp and on UPDATE Current_timestamp are set, the End_time automatically acquires the system time when a new row is created, and when the primary key of the line changes UPDATE, End_ Time is automatically updated to the system up-to-date.

Reference:

78145218

Current_timestamp and on UPDATE current_timestamp differences in MySQL database