Course contentsShow
← Computer Science
Lesson 1572 of 2,87236. Database FundamentalsFree lesson

DELETE Statement for Removing Data

Removing rows from tables using DELETE with WHERE clause and understanding the importance of careful filtering.

DELETE Statement for Removing Data

What you'll learn: How to safely remove specific rows from database tables using the DELETE statement with precise WHERE filtering.

The Core Idea

The DELETE statement permanently removes rows from a table. Unlike UPDATE which modifies existing data, DELETE completely eliminates records from your database. Think of it like erasing entries from a guest list—once deleted, those entries are gone (unless you have backups).

Basic DELETE Syntax

DELETE FROM table_name
WHERE condition;

The WHERE clause is critical—it determines which rows get deleted. Without it, you'll delete every row in the table!

Examples

Delete a specific user:

DELETE FROM users
WHERE user_id = 42;

Delete all orders from a particular customer:

DELETE FROM orders
WHERE customer_id = 7 AND status = 'cancelled';

Delete old records:

DELETE FROM logs
WHERE log_date < '2023-01-01';

The Importance of Careful Filtering

Imagine you want to delete one cancelled order, but accidentally write:

DELETE FROM orders;  -- DANGER: No WHERE clause!

This would delete all orders from the table—a catastrophic mistake. Always double-check your WHERE clause before executing.

Best practice: Before running DELETE, run a SELECT with the same WHERE clause to preview which rows will be affected:

SELECT * FROM orders WHERE status = 'cancelled';  -- Preview first
DELETE FROM orders WHERE status = 'cancelled';     -- Then delete

Key Takeaway: The DELETE statement permanently removes rows matching your WHERE condition; always verify your filter criteria first, because there's no undo button in SQL.