DELETE
Deletes row(s).
Syntax
DELETE FROM table WHERE condition;
Description
Deletes target rows with WHERE. Deletes ALL rows without WHERE.
Example
Loading editor…
Expected output
2
When to use?
Deleting records.
Common mistakes
- ⚠️ DELETE without WHERE empties the entire table.