Java™ How To Program (Early Objects), Tenth Edition

24.4.7 DELETE Statement

A SQL DELETE statement removes rows from a table. Its basic form is

Click here to view code image

DELETE FROM tableName WHERE criteria

where tableName is the table from which to delete. The optional WHERE clause specifies the criteria used to determine which rows to delete. If this clause is omitted, all the table’s rows are deleted. The DELETE statement

Click here to view code image

DELETE FROM Authors   WHERE LastName = 'Black' AND FirstName = 'Sue'

deletes the row for Sue Black in the Authors table. If we know the AuthorID in advance of the DELETE operation, the WHERE clause can be simplified as follows:

WHERE AuthorID = 5

Figure 24.22 shows the Authors table after the DELETE operation has taken place.

Fig. ...