Sql Delete

Use Sql Delete to remove rows in a table.

Similar to Sql Insert and Sql Update, you can do it on a single-row, group of rows or all rows. You can remove rows based on data in other tables using subqueries.

The syntax to delete data in a table:

DELETE FROM table_name
WHERE conditions

Like Sql Update statement, if there is a WHERE condition, it is advisable to test the condition first. Especially if it is a complex WHERE clause. To find out how please check the same process in the sql update.

Let's use the previous table as an example. If you want to delete record with ID number 3 from Tbl_L, then we issue this sql command.

DELETE FROM tbl_L
WHERE ID = 3

The system will tell you how many rows have been deleted. Again, make sure you tested the condition first before running the sql, as you cant undo it later.

If you want to purge the content of a table, use the sql command without WHERE condition.

Let's start learning how to select data using Sql Select.

Couldn't find what you're looking for? Use this search feature to quickly find it!

Positive Resources

All of us have at least two or three things that excite us. We could talk about these subjects for hours. Good news!. Did you know that Site Built It! can turn this type of deep interest and enthusiasm into a revenue-generating business?

Review some of the Site Build It! case studies and you'll absolutely discover something that ignites more positive ideas into your mind.

SBI! Video Tour


Invest the most
important 30 minutes
you will spend online.

Click, sit back, and
understand why SBI!
makes you succeed.