Deleting Rows
The syntax of the DELETE statement is displayed in the graphic. Use of the keyword FROM is optional. The FROM keyword is used to improve readability. table_name identifies the name of the table from which the rows are to be deleted. |
|
The WHERE clause specifies the condition that identifies the rows to be deleted. The WHERE clause can accept any SQL condition, including a subquery. If Sheila omits the WHERE clause, all rows in the table are deleted.