Deleting Data with DELETE
DELETE removes rows from a table. Like UPDATE, always use WHERE to target specific rows.
Basic DELETE Syntax
DELETE FROM table_name WHERE condition;
Warning: Without WHERE, DELETE removes ALL rows!
Exercises
Loading exercise...
Loading exercise...
Loading exercise...
Loading exercise...
DELETE with Products
Loading exercise...
Loading exercise...
Danger: DELETE Without WHERE
-- This deletes EVERY row!
DELETE FROM users;
This is called "truncating" the table. The table structure remains, but all data is gone.
Safe Delete Pattern
Before deleting, SELECT first to see what would be deleted:
-- First, see what you're about to delete
SELECT * FROM users WHERE age < 25;
-- If that looks right, then delete
DELETE FROM users WHERE age < 25;
Free Practice
Loading SQL editor...
Try:
- Delete by email domain
- Delete then count to verify
- Delete and verify the specific rows are gone
التالي · الدرس 25 من 27
Beginner Challenges
قراءة 1 دقيقة
أنهيت 24 من 27 درسًا

اسأل Byte عن هذا الدرس
محادثة خاصة حول هذا الدرس. قرأ Byte الدرس كاملًا، ويجيب خلال ثوانٍ، ويُظهر القسم الذي تأتي منه كل إجابة. يمكنك السؤال بأي لغة.
الأسئلة والأجوبة
أسئلة عامة حول هذا الدرس. يجيب AI Tutor فورًا بلغتك، ويراجع فريق FreeAcademy الإجابات، ويمكن لكل المتعلمين قراءتها.

