🔧 Quick Syntax:
DELETE FROM table_name
WHERE some_condition;
Basically:
“Hey SQL, go to this table, and delete the rows that match this condition.”
⚠️ Warning First
NEVER run DELETE without WHERE
Unless you really want to delete everything 😬
DELETE FROM friends; -- deletes ALL rows!
🧾 Current friends table:
| id |
name |
age |
phone |
| 1 | Olivia | 26 | 5550001234 |
| 2 | Mason | 24 | 5556712345 |
| 3 | Zoe | 30 | 5559083344 |
| 4 | Ethan | 21 | 5554421199 |
| 5 | Harper | 25 | 5552223344 |
✅ Example 1: Delete Ethan from the table
DELETE FROM friends
WHERE name = 'Ethan';
💡 Output:
Query OK, 1 row affected
Table Now:
| id |
name |
age |
phone |
| 1 | Olivia | 26 | 5550001234 |
| 2 | Mason | 24 | 5556712345 |
| 3 | Zoe | 30 | 5559083344 |
| 5 | Harper | 25 | 5552223344 |
✅ Example 2: Delete everyone older than 28
DELETE FROM friends
WHERE age > 28;
💡 Output:
Query OK, 1 row affected
Table Now:
| id |
name |
age |
phone |
| 1 | Olivia | 26 | 5550001234 |
| 2 | Mason | 24 | 5556712345 |
| 5 | Harper | 25 | 5552223344 |
🧃 Recap
DELETE FROM table WHERE condition removes specific rows- NEVER forget the
WHERE unless you’re okay deleting everything
- It’s permanent — no undo unless you’ve got backups
