To remove a row, or all rows from a table, use the DELETE command. The syntax is:






For instance, if the Book Town store does not carry books published by ABC Books and you want to delete it from the table, then use the command:

Example 4-33. Using DELETE

  DELETE FROM publish
        WHERE publ_name='ABC Books';  

The INSERT INTO command can be used to re-insert the data that you have just deleted from your publish table.

Warning Caution with DELETE

If a condition is not specified, then the DELETE command removes ALL rows within that table.