An update can be useful without the set clause but it is syntactically required.
A statement like:
UPDATE records SET records.id = records.id WHERE records.id = x;
will not update any information but will fire the update trigger for the given row.
I have used this in a couple places to log a reset of a record with no information changes.
Leave a comment: