Updating and Deleting Data
Updating a Single Column
Updating Multiple Columns
Deleting a Column Value
Using Subqueries in UPDATE
Updating All Rows
Deleting Specific Rows
Deleting All Rows
Using Subqueries in DELETE
DELETE
FROM
customer
WHERE
address_id =
1
DELETE
FROM
requires that you specify the name of the table
from
which the data is to be deleted. The
WHERE
clause filters which rows are to be deleted.