Tutorials Hut

  • SQL Testing




  • SQL Delete Statement with Example

    SQL Delete Statement is used to delete one or more records from a table.

      • We can delete all records in a table or can delete only particular records in a table using DELETE statement.
    Synatx
    DELETE FROM table WHERE condition

    Deleting All Rows

    DELETE FROM table;

    Deleting Specific Rows

    DELETE FROM table
    WHERE conditions;

    Example:

    Employee Table having below records

    SQL Delete statement 1

    Delete Employee record from Employee Table  whose first name is ‘Praj’

    mysql> Delete from Employee where Employee_FirstName='Praj' ;

    Query OK, 1 row affected (0.17 sec)

    Recommended Articles:




  • SQL Testing


















  • Leave a Reply

    Your email address will not be published. Required fields are marked *