Oracle Database 11g & MySQL 5.6 Developer Handbook

he DELETE FROM statement lets you remove data from tables and views. There are two types of DELETE FROM statements: One uses literal values or subquery comparisons in a WHERE clause; the other uses correlated results from a subquery. It is also possible to combine values or subquery results with correlated results in the WHERE clause. MySQL offers a variation on correlated statements with a multiple-table DELETE FROM statement. This chapter covers how you use both statements.

Like the UPDATE statement, a DELETE FROM statement removes all rows ...