Data changes over time: people get raises, and old records must be removed. UPDATE changes values in existing rows and DELETE removes rows. Use them with a WHERE clause that picks exactly the rows you mean, because without one every row in the table is changed or deleted. Running the same WHERE as a SELECT first is a good habit before any update or delete.