Timestamp-type automatic update time when the record is updated in MySQL

This feature is required for projects. When I use navicat to set the date type to timestamp, I will find that IDE has one more option:

This feature is required for projects. When I use navicat to set the date type to timestamp, I will find that IDE has one more option:

This feature is required for projects.

When I use navicat to set the date type to timestamp, I will find that IDE has one more option:

View the SQL statements automatically generated by IDE:

Write

'Lastupdate' timestamp not null default '2017-00-00 00:00:00 'on update CURRENT_TIMESTAMP

If this option is removed:

Write

'Lastupdate' timestamp not null default '2017-00-00 00:00:00'

The difference is "on update CURRENT_TIMESTAMP", which is used when the record has"Change"The lastUpdate time is automatically updated to the current time of the system.

Note: The change is emphasized. In other words, this value will not be automatically updated even if the update statement is used but the content does not change.