Tutorials
How to insert image in MySQL database using sql query?
PHP WHERE clause example to fetch records from Database Table
MySQL NOT IN
SQL GROUP BY Example
aftertrigger
Mysql Time Trigger
Mysql last row
MySQL Append
MySQL Add Column
Mysql Alter Table
Mysql Alter Data Type
Mysql Alter Column
SQL All Tables
Mysql Alter Rename Table
Mysql Alter Procedure
PHP SQL Where
PHP SQL Array
Mysql Merge
Mysql Group By
MySQL Append String
MySQL Append Data
MySql Append Codes
MySQL Add Column
SQL All Column Names
PHP SQL Insertion
MySQL Arithmetic
SQL Aggregate Functions
Mysql Merge Statement
SQL Alter Table
MySQL PHP Update
MySQL PHP Query delete
Mysql Alter Rename Table
SQL Update
Mysql PHP Where
SQL Alter Database
MySQL ASC
MySQL Aggregate Function
PHP SQL Select
MySQL Area
PHP SQL Fetch
The DELETE Statement
In this section, you will learn use of the delete statement.
In this section, you will learn use of the delete statement.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 |
Ads
