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
1	Tom	34	Paris	5300
2	Jhony	51	London	400
3	Ram	64	Delhi	20000.7
4	Simon	23	Portland	32.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;