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

Development Tools Database Foundations Introduction to Data, Databases and SQL Creating Tables

Don Shipley
Don Shipley
19,488 Points
Posted by Don Shipley
Don Shipley
19,488 Points

On the test Create a table called "movies" with a VARCHAR column named "title" and an INTEGER column named "year".

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

SQL Error: table movies already exists

Test will not pass What am I suppose to do?

2 Answers

Charalampos Anargyrou
Charalampos Anargyrou
14,031 Points

The SQL Error, indicates that the table with the name movies cannot be created because it already exists. It looks like you have already created the table.

Don Shipley
Don Shipley
19,488 Points
Don Shipley
Don Shipley
19,488 Points

Yes that is what it is to mean Thank you. But before this it would not create the table. CREATE TABLE movies (title VARCHAR(255), year INTEGER); With that code it kept telling me I had an error. I wrote to support all is well now.

I even looked up how to DROP TABLE movies and inserted it on the question. LOL Who knows maybe that fixed it.

Thank you for your reply