How to delete data from an sql table?

Example:

-- Incorrectly attempting to delete data without a WHERE clause
DELETE FROM customers;
Solution:

-- Correctly deleting data with a WHERE clause
DELETE FROM customers WHERE name = 'John Doe';
The DELETE statement removes rows from a table. Using a WHERE clause ensures you don't delete all the data in the table unintentionally.

Beginner's Guide to SQL