SQL update syntax

Because I always forget this, I’m putting it here:

UPDATE persons
SET
  address='Nissestien 67', city='Sandnes'
WHERE
  last_name='Tjessem' AND first_name='Jakob'

October 4 2011, 11:10 PM  by David Parr

Discuss...