DELETE statement is used to delete the records of a table.
<?php
DELETE FROM table_name WHERE condition;
?>
If you want to delete a specific customer details from customer table:
<?php
DELETE FROM Customers WHERE CustomerName='john';
?>
If you want to delete all the records of customer table:
<?php
DELETE FROM Customers;
?>