Skip to main content

2

sql

-- View all current clients
SELECT * FROM clients;

-- Update the email of Jason Green (previously inserted)
UPDATE clients
SET email = 'j.green@newdomain.com'
WHERE name = 'Jason Green';

-- Update both email and signup_date for Laura Adams
UPDATE clients
SET email = 'laura.adams@newdomain.com', signup_date = '2023-04-10'
WHERE id = 4;

-- Confirm updates
SELECT * FROM clients;

Want to learn more?

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

sql