SQL DELETEDELETE statement is used to delete row(s) in a table.
DELETE FROM table_name WHERE column_name=column_value;
Where clause in the above syntax means that the changes will be reflected by DELETE in only those rows in which codition is satisfied.
Example 1 : Delete all Records from a Table
DELETE FROM customers;
Example 2 : Delete a particular Record from a Table
DELETE FROM customers WHERE id=1;