4.2.3 The UPDATE statement

The UPDATE statement

Updates values of one or more attributes of one or more tuples in a table.

General form:

UPDATE

SET

[ WHERE ];

Sample UPDATE statements from the Case Example

Query 38: changes price of itmem SW1 to 6000

UPDATE items

SET price = 6000

WHERE item# ='SW1';

Query 39: Changes a wrongly entered item# from HW2 to SW2

UPDATE ord_items

SET item# = 'SW2'

WHERE ord#=104 AND item# = 'HW2';