Learn Manipulation - Create a Table Project unable to add VALUES after INSERT INTO statement

I am new to codecademy so firstly hello.

Secondly, I am trying to complete the ‘Create a Table’ project and I can’t get past steps 2 and 3. I have reset the project a handful of times.

In step 1, I can create the ‘friends’ table as I see it in the database schema. I then try and add the Jane Doe value, but alas my values are not needed.

Any help is much appreciated. I am sure that I have made a simple error but I can’t see it.

1 Like

Hi - welcome to the forum!

I am not sure whether it’s the intended behaviour, but you need to write your INSERT statement underneath the code which declares your table.

If you remove the CREATE TABLE statement, it doesn’t seem to work…

Like I said, I am not sure whether this is intended. I’ll try and find out. :slight_smile:

@thepitycoder - Thank you. I have now completed the project. The only way I got it to work was to have all statements in the editor otherwise if I ran (Saved) them after each task, nothing was returned.

1 Like

Yeah…

It took me a number of attempts before I figured that out… :frowning:

1 Like

Thanks for the quick answer!

1 Like