sql-training/01-lessons/02-intermediate/02-data-modification/06-basic-delete.sql at main · Morobang/sql-training · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
-- ========================================
-- Basic DELETE: Remove a Single Row
-- ========================================

USE TechStore;

-- Before: See all customers
SELECT * FROM Customers;

-- Delete customer 5 (James Martinez)
DELETE FROM Customers
WHERE CustomerID = 5;

-- After: Verify customer 5 is gone
SELECT * FROM Customers;