w1coding.comAll tutorials

SQL Delete

SQL lessons
  1. Environment Setup
  2. Introduction
  3. Select
  4. Where
  5. Decision
  6. Insert
  7. Delete
  8. Distinct
  9. Limit
  10. Operator
  11. In
  12. Join
  13. Leftjoin
  14. Rightjoin
  15. Fulljoin
  16. Groupby
  17. Having
  18. Order
  19. Update

SQL DELETE Statement

The DELETE statement is used to remove rows from a table.

Basic DELETE Query

DELETE FROM Users
WHERE first_name = 'John' AND last_name = 'Doe';
    

This query deletes the user with the first name "John" and last name "Doe" from the "Users" table.