The DELETE Statement

In this section, you will learn use of the delete statement.

Ads

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. 

Syntax

 

 

 

 

 

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

Advertisements

Ads
Share on Google+Share on Google+

The DELETE Statement

Posted on: September 15, 2007 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

Ads
 

Discuss: The DELETE Statement   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:1
Radhika.S.N
February 18, 2013
very good

This site so help for my project . wonderful

Ads

 

Ads