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

Posted by Michael Horstkoetter
Michael Horstkoetter
Courses Plus Student 9,061 Points

Error with Query 1 from Database Foundations 'SELECT * FROM movies;' on localhost.

I'm having an issue with Querying on my localhost server.

I have imported the 'treehouse_movie_db' and executed the script, and can view 'treehouse_movie_db' in the schema section of my workbench.

I then tried to run the query 'SELECT * FROM movies;' and the response from the Action Output are two.

First: 12:35:12 SELECT * FROM movies LIMIT 0, 1000 Fetching... 0.00063 sec / ?

Second: 12:35:12 SELECT * FROM movies LIMIT 0, 1000 Error: Error formatting SQL query: empty string given as argument for ! character

Any suggestions on what might be happening?

moonshine
moonshine
8,449 Points

I don't know unless I try myself, but is this post helpful to you?

1 Answer

Michael Horstkoetter
PLUS
Michael Horstkoetter
Courses Plus Student 9,061 Points
Michael Horstkoetter
Michael Horstkoetter
Courses Plus Student 9,061 Points

THAT WORKED! Um please excuse me, Floris Creyf; no, you're awesome.

First, select the specific database schema in the MySQL Workbench (to the left) so that the letters become bolded.

Second, run the query.

Proceed to dance around the room, in PJs.