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
Polyglot developer, geometric tessellation fan, ambient DJ.
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