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

Brian Baker
Brian Baker
471 Points
Posted by Brian Baker
Brian Baker
471 Points

What is the proper syntax for challenge task 1 of 2

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.

1 Answer

William Li
PLUS
William Li
Courses Plus Student 26,868 Points
William Li
William Li
Courses Plus Student 26,868 Points

Are you getting a syntax error?

Here's one way of doing it

CREATE TABLE movies (year INTEGER, title VARCHAR(255));
Brian Baker
Brian Baker
471 Points
Brian Baker
Brian Baker
471 Points

Thank you, I was getting an error. I went back and took notes and found my mistake. Thanks