Manipulation Project - Not displaying Query after making table


#1

Hello All,

I am having problems with the project, nothing displays in the query after making the table. Can you look at my code and tell me what I am missing?

CREATE TABLE friends (id INTEGER, name TEXT, birthday DATE);

INSERT INTO friends (id, name, birthday)
VALUES (1, 'Jane Doe', 5/19/1993);

INSERT INTO friends (id, name, birthday)
VALUES (2, 'Charlotte Viberry', 4/22/2014);

INSERT INTO friends (id, name, birthday)
VALUES (3, 'Annika Viberg', 6/15/2012);

INSERT INTO friends (id, name, birthday)
VALUES (4, 'Johan Wiberg', 10/03/1978);

UPDATE friends
SET name = 'Jane Smith'
WHERE id = 1;

ALTER TABLE friends ADD COLUMN Email TEXT;

UPDATE friends
SET Email ='jdoe@example.com'
WHERE id= 1;

UPDATE friends
SET Email = 'cviberry@example.com'
WHERE id =2;

UPDATE friends
SET Email = 'aviberg@example.com'
WHERE id =3;

UPDATE friends
SET Email = 'jwiberg@example.com'
WHERE id =4;

DELETE FROM friends WHERE id =1;

Thanks.


#2

Your dates will need quotes.

If this were me, I could copy all that code and save is somewhere and then put it back line by line and test it each time.

SQL doesn't give you any error checking there so if there is a mistake you could be days finding it if you don't reduce the size of the code you have to hunt through.

Put a SELECT * from friends at the end so you can see what is happening.