Profile

cnoocy: green a-e ligature (Default)
(boing!) Cnoocy Mosque O'Witz

Expand Cut Tags

No cut tags
cnoocy: green a-e ligature (Default)
[personal profile] cnoocy
The WHERE clause specifies the rows to update. For example, consider the unlikely event that northern California is renamed Pacifica (abbreviated PC) and the people of Oakland vote to change the name of their city to Bay City. This example shows how to update the authors table for all former Oakland residents whose addresses are now out of date.

UPDATE authors
SET state = 'PC', city = 'Bay City'
WHERE state = 'CA' AND city = 'Oakland'

You must write another statement to change the name of the state for residents of other northern California cities.

Date: 2004-08-26 09:02 am (UTC)
From: [identity profile] rikchik.livejournal.com
Best to be prepared for these sorts of things.

Most Popular Tags

Style Credit

Page generated Jul. 20th, 2025 02:31 pm
Powered by Dreamwidth Studios