<p>My database table has a column defined to use <code>ON UPDATE CURRENT_TIMESTAMP</code>:</p> <ul> <li>Field: last_access</li> <li>Type: timestamp </li> <li>Collation:</li> <li>Attributes: on update CURRENT_TIMESTAMP</li> <li>Null: No</li> <li>Default: CURRENT_TIMESTAMP</li> <li>Extra: ON UPDATE CURRENT_TIMESTAMP</li> </ul> <p>How can I force this <code>last_access</code> field to update for a given record when no other data in the record is changing?</p>

How to Force UPDATE of MySQL Record When Nothing Is Changing

UPDATE your_table SET last_access = CURRENT_TIMESTAMP(); ?

answered Oct 08 '22 15:10

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!