SQL DELETE

DELETE statement is used to delete row(s) in a table.

SYNTAX :
DELETE FROM table_name
WHERE column_name=column_value;

Must Read:

Where clause in the above syntax means that the changes will be reflected by DELETE in only those rows in which codition is satisfied.


Table Name 'customers'

id

name

age

city

bill

1Tom34Paris5300
2Jhony51London 400
3Ram64Delhi20000.7
4Simon23Portland32.65

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;