SQL DELETE Statement

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

Basic Syntax

<?php  

	DELETE FROM table_name WHERE condition; 

?>

Example

Specific Record

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

<?php  

    DELETE FROM Customers WHERE CustomerName='john';

?>


All Record

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

<?php  

    DELETE FROM Customers;

?>