28.2.6 Updating and Deleting Data

UPDATE modifies fields in record(s)

UPDATE Item
   SET Quantity = Quantity + 1
   WHERE Invoice_Number = '11731'

Update multiple fields by putting multiple expressions separated by commas in the SET clause