Skip to main content

3

sql

-- View all clients before deletion
SELECT * FROM clients;

-- Delete a client by name
DELETE FROM clients
WHERE name = 'Jason Green';

-- Check the table after deleting a client
SELECT * FROM clients;

-- Delete all records (use with caution!)
DELETE FROM clients;

-- Check the table after deleting all records
SELECT * FROM clients;

Want to learn more?

Join CodeFriends Plus membership or enroll in a course to start your journey.

sql