SQL Delete Query With Example

.

SQL DELETE Statement - How to Delete record from table in SQL?

Delete query in SQL with Example

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.

How to Delete all records From a database?

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

.