previous
|
start
|
next
Updating and Deleting Data
The UPDATE query lets you update columns of all records that fulfill a certain condition
To add one to the quantity of every item in invoice number 11731
UPDATE Item SET Quantity = Quantity + 1 WHERE Invoice_Number = '11731'
Both UPDATE and DELETE return the number of rows updated or deleted
previous
|
start
|
next