SQL DELETE statement allows you to delete a single record or multiple records from a table or an entire records in a table.

The syntax for the SQL DELETE statement is:

For Deleting an entire records in a table

[sql] DELETE FROM table_name WHERE;

Delete only specific records from a table, For this purpose we can use WHERE clause and can only delete selected records.
[sql] DELETE FROM table_name WHERE [condition];

In WHERE clause we can use AND, OR conditions.

Vivek Vengala

Vivek Vengala is a Online Entrepreneur, Web Developer from Hyderabad India.

Click Here to Leave a Comment Below 0 comments

Leave a Reply: