|
Let's update a Price into a row that
doesn't have a price listed yet:
UPDATE ANTIQUES SET PRICE = 500.00
WHERE ITEM = 'Chair';
This sets all Chair's
Prices to 500.00. As shown above,
more WHERE conditionals, using AND,
must be used to limit the updating
to more specific rows. Also, additional
columns may be set by separating equal
statements with commas. |
