SQL DELETE

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

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.

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:

x

Join My Facebook Group to Receive Coding Tutorial for Free

email-subsribe