SQL Tutorial


      Basics

    1. Introduction
    2. Database Structure

      Commands

    3. Create
    4. Select
    5. Insert
    6. Update
    7. Delete
    8. Drop

      Operations

    9. Joining Tables

      Appendices

    10. Terms
    11. Credits

SQL Delete Command

This command is used to delete rows or records in a table. The syntax of this command is:

delete from "tablename"
where columnname OPERATOR value [and|or 
columnnamex OPERATOR valuex]; 

Without the where clause, all records in the table will be deleted.

Example

delete from citylist
where name = 'Argos' and state = 'Indiana';