SQL
DELETE Statement

DELETE statement is used to delete the records of a table.

Basic Syntax

DELETE FROM table_name WHERE condition;

Example

Specific Record

If you want to delete a specific customer details from customer table:


 

    DELETE FROM Customers WHERE CustomerName='john';

All Record

If you want to delete all the records of customer table:



    DELETE FROM Customers;