September 2007
Intermediate to advanced
672 pages
13h 23m
English
The DELETE statement has only three keywords: DELETE, FROM, and WHERE. You can see the diagram of the DELETE statement in Figure 17-1.
We said that the DELETE statement is perhaps the simplest statement in SQL, and we weren’t kidding! But it’s also the most dangerous statement that you can execute. If you do not include a WHERE clause, the statement removes all the rows in the table you specify. This can be useful when you’re testing a new application, for example, so you can empty all the rows from existing tables but keep the table structure. ...