Exercise 4


#1

CREATE TABLE celebs (id INTEGER, name TEXT, age INTEGER);
INSERT INTO celebs (id, name, age) VALUES (1, 'Justin Beiber', 21);
SELECT * FROM celebs;

My first 3 rows look like this...I'm not sure where the error is at...

According to the task: To view the row you just created, under the INSERT statement type

Am I missing something?


#2

No, you have something extra that this exercise isn't expecting. Remove the CREATE TABLE command.


#3

yeah, figured it out a little late...Thanks for the help though


#4

celebs (id INTEGER, name TEXT, age INTEGER);
INSERT INTO celebs (id, name, age) VALUES (1, 'Justin Beiber', 21)
SELECT * FROM celebs;

This is mine but what is the wrong with this?


#5

You need to remove the entire command.