mysqlonupdate

How to Force UPDATE of MySQL Record When Nothing Is Changing


My database table has a column defined to use 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?


Solution

  • UPDATE your_table SET last_access = CURRENT_TIMESTAMP(); ?