Skip to main content

1

sql

-- View current clients
SELECT * FROM clients;

-- Insert a new client using column list
INSERT INTO clients (id, name, email, signup_date)
VALUES (4, 'Laura Adams', 'laura.adams@example.com', '2023-03-05');

-- Insert a new client without specifying columns
INSERT INTO clients
VALUES (5, 'Jason Green', 'jason.green@example.com', '2023-12-14');

-- View updated clients
SELECT * FROM clients;

Want to learn more?

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

sql