Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Databases Creating and Modifying Database Tables Creating and Modifying Database Tables Creating a Table

Nicholas Angelini
Nicholas Angelini
1,348 Points

Receiving errors in sql playground launchpad.

Hi,

i've been running the sql basics tracks and I've been getting syntax errors creating basic tables. I also noticed that Playground isn't highlighting / recognizing keywords ie: INT, SMALLINT, DATE etc...

I've copied and pasted the code used to create the table i'm getting an error for whenever I select run. I've tried troubleshooting, ie: restarting the browser (chrome), going to the beginning of the track and launching the pad there. I've RESET multiple times. I've noticed slight variations between the instructional videos and launchpads throughout this course, HTML and CSS.

CREATE TABLE ( ID SMALL INT, DATE DATE, CITY VARCHAR(255), STATE VARCHAR(255), VENUE VARCHAR(255) );

Error: near "(": syntax error

2 Answers

Steven Parker
Steven Parker
218,596 Points

The name of the table should go between "CREATE TABLE" and the opening parenthesis.

Also, as SQLite is a typeless DB, the type names are allowed but have no significance to the system.