-- incrementing a field in one atomic operation
UPDATE bankAccount SET balance = balance+? WHERE accountNumber=?

-- setting a field to the highest value so far, all in one atomic operation
UPDATE vendors SET highestConfirm=GREATEST(?,highestConfirm) WHERE vendorId=?