Maybe the wrong forum, but Create A Table in the Introduction

I’ve just started (yesterday), and I’m working on the “Create A Table” bit. I can’t move on from the first slide/set of instructions.

I started by creating my own table but followed the guidelines, and when that was complete I couldn’t move on. I cleared my own code out and copied the code used in the hints EXACTLY, assuming the checker was looking for specific things. No dice.

I’ve noticed that in the results panel it shows a schema from the “celebs” table in the initial project. I’ve tried to delete that table, but being new I’m not experiencing any success with that.

How do I move on to step…2?

Hello @drewphoria welcome to the forums. Could you please provide a link to the excise and your code formatted using this:Screen Shot 2020-04-22 at 08.30.10.

Link

I’m not sure what the format you were trying to show is, but the code is below.

#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, ‘Karen Krabapple’, ‘1965-08-15’);
#INSERT INTO friends (id, name, birthday)
#VALUES (3, ‘Patty Bouvier’, ‘1949-12-01’);

#UPDATE friends
#SET name = ‘Jane Smith’
#WHERE id = 1;

#ALTER TABLE friends
#ADD COLUMN email TEXT;

#UPDATE friends
#SET email = ‘jane@codecademy.com’
#WHERE id = 1;

#UPDATE friends
#SET email = ‘karen@codecademy.com’
#WHERE id = 2;

#UPDATE friends
#SET email = ‘patty@codecademy.com’
#WHERE id = 3;

#DELETE FROM friends
#WHERE id = 1;

#SELECT * FROM friends;

The problem is that you are working on a project. To complete tasks in a project, you have to manually check the boxes. So whether your code will suffice is up to you.

1 Like