How to Delete Data from SQL

Need to remove data from a database?

Use DELETE.

Common examples:

• DELETE removes rows
• WHERE specifies which rows
• No WHERE means all rows
• Transactions help protect changes
• ROLLBACK helps when something goes wrong

Before executing a DELETE, make sure your WHERE condition selects the rows you want to remove.