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

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

Posted by Nicholas Angelini
Nicholas Angelini
1,538 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
231,271 Points
Steven Parker
Steven Parker
231,271 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.

Nicholas Angelini
Nicholas Angelini
1,538 Points
Nicholas Angelini
Nicholas Angelini
1,538 Points

Thank you !