Manipulation Project - not showing up on the query


#1

I typed in the first part and the project and hit save and it populated the query
Did the 2nd. 3rd 4th...etc.. task and nothing
does this look correct

CREATE TABLE Friends (ID integer, Name Text, Birthday Date);

INSERT INTO Friends (ID, Name, Birthday)
VALUES (1, 'jane doe', 1993-05-19);

INSERT INTO Friends (ID, Name, Birthday)
VALUES ('2','Jane Doo','1993-05-19') VALUES (3,'Jack Doe','1993-04-19') VALUES ('4','JOe Doe',1992-03-19);

UPDATE Friends
SET Name='Jane Doe'
WHERE Name='Jane Smith';

ALTER TABLE Friends
ADD column Email Text;

UPDATE Friends
SET Name='Jane Doe', Name='Jane Doo', Name='Jack Doe', Name='Joe Doe'
WHERE Email='jdoe@example.com', Email= 'jdoo@example.com', Email='jdoe1@example.com', Email= 'jdoo2@example.com';

DELETE FROM Friends
WHERE Name='Jane Doe';


#2

Ok I listed them all I have to clear out the previous.... :grinning:


#3

Actually no its not working


#4

I'm having some trouble with this exercise, too. When I insert Jane Doe into friends, I should be able to query the database with:

SELECT * FROM friends;

But that query doesn't spit out anything (which I think it should, right?)


#5

You will need quotes on that date.


#6

Yes it should my other issue was my dates need ' before and after


#7

I mean " thats what you need to use


#8

Works today. I think my insert statement was wrong.