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
UPDATE
newCustomer
SET
last_update =
NULL
If the
WHERE
clause
is
not
specified, the query updates
all
rows
in
the table.
Some DBMSs allow database administrators to impose restrictions that prevent the execution of
UPDATE
without a
WHERE
clause.