The DELETE Statement, SQL Tutorial
Posted on: April 18, 2011 at 12:00 AM
Posted on: April 18, 2011 at 12:00 AM
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 |
- Quartz Tutorial
- Advance (Enterprise) Features
- Aggregate Functions in SQL, SQL Tutorial
- Backup File With Separator
- Backup Into txt File
- Backup selected records into txt file
- Call Procedure
- Close Cursors in SQL
- Configuration, Resource Usage and StdSchedulerFactory
- Create After Insert Trigger in SQL
- Create Before Insert Trigger in SQL
- Create Before Update Trigger in SQL
- Create Delete Trigger in SQL
- Create a Simple Procedure
- Create After Update Trigger in SQL
- Create Database in SQL,SQL Tutorial
- Creating Cursors in SQL
- More About the CronTrigger
- Declare Cursors in SQL
- The DELETE Statement, SQL Tutorial
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
Ask Questions? Discuss: The DELETE Statement, SQL Tutorial
Post your Comment