Online Training Spring Hibernate Training in Delhi R Programming Training Course Big Data and Hadoop Training Java Training

The DELETE Statement, SQL Tutorial

This page discusses - The DELETE Statement, SQL Tutorial

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

Online Training Classes

Share on Google+Share on Google+

The DELETE Statement, SQL Tutorial

Posted on: April 18, 2011 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

 

Discuss: The DELETE Statement, SQL Tutorial  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0

Ads

 

Ads