News

Modifies a column's values in existing rows of a table or view. Restriction: You cannot use UPDATE on a table accessed via an engine that does not support UPDATE processing. You can update one or more ...
One will update all the rows in a, and the other will only update matching rows. Depending on your schema, that might be fine, but as others have mentioned, it might trip all of your timestamps.