Updating and Deleting Data

• The DELETE and UPDATE commands modify the database
• The DELETE command deletes rows
• To delete all customers in California

  DELETE FROM Customer WHERE State = 'CA'