O'Reilly logo

Oracle Database 11g & MySQL 5.6 Developer Handbook by Michael McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

image

image

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required