The DELETE Statement

The DELETE statement is used to delete rows from a table. database will update that is why deletion and insertion of data will be done.

DELETE FROM table_name
WHERE column_name = some_value

Let's consider a table :

Person:

LName	FName	Address
ram	Raj	delhi-5
sonu	Shiv	delhi-5

To Delete a Row :

Suppose the row with Lname="sonu" is needed to get deleted
.

DELETE FROM Person WHERE LName = 'sonu'

Result

LName	FName	Address
ram	Raj	delhi-5

To Delete All the Rows : This means that the table structure, attributes, and indexes will be drop.

DELETE FROM table_name

«Previous Index Next»

Recommend the tutorial

Ask Questions? Discuss: The DELETE Statement View All Comments

Post your Comment

Comments

Radhika.S.N
February 18, 2013
very good

This site so help for my project . wonderful