Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

PHP

Posted by Federico Giust
Federico Giust
8,157 Points

Database Foundations - Create Table movies error

Hi Guys,

I'm going through database foundations and I'm stuck in one of the code challenges.

The challenge is to create a table called movies with two columns title VARCHAR(255) and year INTEGER.

I'm using this statement which seems to be correct

CREATE TABLE IF NOT EXISTS movies ( title VARCHAR(255), year INTEGER);

But I keep getting this error

The types for title and year are incorrect. Use VARCHAR(255) and INTEGER respectively.

9 Answers

Christopher Hall
Christopher Hall
9,052 Points
Christopher Hall
Christopher Hall
9,052 Points

I believe that you should be using the keyword INT instead of INTEGER. Such as:

CREATE TABLE IF NOT EXISTS movies ( title VARCHAR(255), year INT);
Federico Giust
Federico Giust
8,157 Points
Federico Giust
Federico Giust
8,157 Points

I tried both INT and INTEGER and still getting the same error

James Kennedy
James Kennedy
20,755 Points
James Kennedy
James Kennedy
20,755 Points

try get rid of the "if not exists" I have noticed a few problems in these coding challenges not recognising optional parts. Try Create table movies(title varchar(255), Year Integer);

Federico Giust
Federico Giust
8,157 Points
Federico Giust
Federico Giust
8,157 Points

Tried that already. When I remove the if not exists it throws an error saying that the table already exists.

James Kennedy
James Kennedy
20,755 Points
James Kennedy
James Kennedy
20,755 Points

If this is your question: Create a table called "movies" with a VARCHAR column named "title" and an INTEGER column named "year". The title should be up to 255 characters long. I just tried the SQL statement create table movies (title varchar(255), year integer) and it worked first time?

Federico Giust
Federico Giust
8,157 Points
Federico Giust
Federico Giust
8,157 Points

Not sure what was going on but when I posted this I tried with

create table movies (title varchar(255), year integer); create table if not exists movies (title varchar(255), year integer); create table movies (title varchar(255), year int); create table if not exists movies (title varchar(255), year int);

The only difference was that I was trying with the datatypes in uppercase. I now tried again with the datatypes in lowercase and without the semicolon and it works now...

Julian Ptak
Julian Ptak
30,920 Points
Julian Ptak
Julian Ptak
30,920 Points

Did anyone solve this? I'm stumbling on this question with a similar problem. Nothing I'm trying is working.

David Ruiz
David Ruiz
4,802 Points
David Ruiz
David Ruiz
4,802 Points

I think it's a mistake on their side, and they should do something about it, or at least post something here. It's really frustrating to have to learn on your own, so many times making mistakes and having to work out what you did wrong without on top of it have the code not pass when you typed it right. Anger!

Glen Sutton
Glen Sutton
3,809 Points
Glen Sutton
Glen Sutton
3,809 Points

Yep, I got stuck on that as well. It's really frustrating. Glad it is not only me.