mysql update不修改,MySQL：更新而不更改数据，可能吗？

Is it possible in MySQL to update a row, without changing any data?

I just need a trigger to do its work, but the data should not be changed.

Of course I could do an update and then another update, but the trigger is quite slow (deletes and inserts 500 rows everytime) and I have to update thousands of rows, so I'd rather not do it twice.

I could also just update a dummy field with NOW(), but I'm just curious if it's possible without 'tricks'.

解决方案

How about:

UPDATE table SET id=id WHERE ...