How to Force UPDATE of MySQL Record When Nothing I

Question

My database table has a column defined to use ON UPDATE CURRENT_TIMESTAMP:

• Field: last_access
• Type: timestamp
• Collation:
• Attributes: on update CURRENT_TIMESTAMP
• Null: No
• Default: CURRENT_TIMESTAMP
• Extra: ON UPDATE CURRENT_TIMESTAMP

How can I force this last_access field to update for a given record when no other data in the record is changing?

Answer 1

UPDATE your_table SET last_access = CURRENT_TIMESTAMP(); ?