sql
SQL Delete Query With Example
.
SQL DELETE Statement - How to Delete record from table in SQL?
SQL Delete Statement
IN SQL DELETE Query is used to
delete existing records in a table.
DELETE Syntax -
The Basic Syntax For the DELETE table is as Follows
DELETE syntax for deleting the specified record from the table.
DELETE FROM table_name WHERE condition;
DELETE Syntax to record all the Column From the table.
DELETE FROM table_name;
How to Delete a specific record From a database?
Example
DELETE FROM Student WHERE StudentName='Ram;
Example Explanation
In the above Query, it will Delete the student whose name is ram from the
Student table.
Example
DELETE FROM Customers;
Explanation
In the above Query, it will Delete all the Row Present in the Student table .it
Will Not delete the table just Delete
all the Columns.
Hope!!! The above tutorial on "DELETE Statement with Example" is helpful For you...
Team,
QA acharya
Tags: Delete Statement with example, Delete statement example
.
Post a Comment
0 Comments