When I add an update the output goes blank. This is the lesson:
Working With Your First Database | Codecademy
And this is my code, it does not even work by id as the video shows. Any help is appreciated.
CREATE TABLE friends (
id INTEGER,
name TEXT,
birthday DATE
);
INSERT INTO friends (id, name, birthday)
VALUES (1, ‘Jane Doe’, ‘1990-05-30’);
INSERT INTO friends (id, name, birthday)
VALUES (2, ‘Prahlad’, ‘2011-03-23’);
INSERT INTO friends (id, name, birthday)
VALUES (3, ‘Uma’, ‘2014-05-24’);
UPDATE friends
WHERE name = ‘Jane Doe’
SET name = ‘Jane Smith’;
ALTER TABLE friends
ADD COLUMN email TEXT;
UPDATE friends
SET email = ‘prahlad@gmail.com’
WHERE id = 2;
UPDATE friends
WHERE name = ‘Uma’
SET email = ‘uma@gmail.com’;
SELECT * from friends;