Database Reference
In-Depth Information
fusing. The
FROM
clause lists the tables from which data is to be deleted. There is also a
USING
clause that lists the tables again and how they are joined. What is significant about
this distinction is that we must list the tables in which rows are to be deleted in the
FROM
clause. If we did not include
prize_winners
in that list, no rows would be deleted
from it — only rows from
humans
would be deleted.
There are several contortions and options in the syntax for
DELETE
. However, at this
stage, the methods we reviewed in this chapter will serve well for almost all situations you
will encounter as a MySQL and MariaDB developer oradministrator.