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

Where do we create this table? Do I use workspace, myphpadmin, CMD, etc?

This might be a dumb question but where do we create the table? There's no workspace attached to this, he didn't mention myphpadmin, CMD or anything? I honestly don't understand where I'm suppose to write the code to create this table. Andrew Chalkley

3 Answers

Michael Hall
PLUS
Michael Hall
Courses Plus Student 30,909 Points

it doesn't seem to be clear where you would do this.

I would suggest you download sequel pro https://www.sequelpro.com/

Thank you Michael, checking it out right now.

Kevin Korte
Kevin Korte
28,148 Points

You could use the code to create the table in phpmyadmin, but since it's always a GUI that will take a few "Create Table" clicks and do the exact same thing, I wouldn't.

You application could also technically have this code, but if your application dynamically generates new tables, you probably need to rethink your schema.

If you were to manage your database from the command line, you could use it there too - it just depends on how or what you'll use to manage it.

Andrew Chalkley
STAFF
Andrew Chalkley
Treehouse Guest Teacher

This video was an over view to the syntax. The next code challenge is where you type them in.

Ok thank you