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 Installing MySQL Server and MySQL Workbench Running a Script and Using MySQL Workbench

Posted by Satbir Singh
Satbir Singh
1,674 Points

select * query in workbench not returning any record...

now treehouse_movie_db is in my workbench when i type the following query...

select * from movies;

this shows the following error Error: Error formatting SQL query: empty string given as argument for ! character

7 Answers

Aamir Mirza
Aamir Mirza
25,077 Points
Aamir Mirza
Aamir Mirza
25,077 Points

I think this happens when you haven't selected a database. You have to double-click on treehouse_movie_db on the sidebar to select it (it should be bold).

taahrqqhar
taahrqqhar
14,147 Points

thank you I just had the same problem

Erich Stauffer
Erich Stauffer
1,632 Points

You're right. I went back and watched that part. The database is already bold when he refreshes the screen and he doesn't mention to double-click on it, which is a critical step.

Oziel Perez
Oziel Perez
61,321 Points
Oziel Perez
Oziel Perez
61,321 Points

Yep just here to confirm the same thing. Video should be updated to mention that database must be selected. I was having the same problem.

Satbir Singh
Satbir Singh
1,674 Points
Satbir Singh
Satbir Singh
1,674 Points

Thanks Aamir

David Wilkinson
David Wilkinson
9,716 Points
David Wilkinson
David Wilkinson
9,716 Points

You could also try the following query:

SELECT * FROM treehouse_movie_db.movies;

Stephen Little
Stephen Little
8,312 Points
Stephen Little
Stephen Little
8,312 Points

ya I was using the treehouse_move_db.movies, thanks for pointing out we need to double click :)

Cheers@!

Gary Calhoun
Gary Calhoun
10,317 Points
Gary Calhoun
Gary Calhoun
10,317 Points

Thanks that worked!!

Marston Gould
seal-mask
.a{fill-rule:evenodd;}techdegree
Marston Gould
PHP Development Techdegree Student 17,314 Points
Marston Gould
.a{fill-rule:evenodd;}techdegree
Marston Gould
PHP Development Techdegree Student 17,314 Points

Actually, I'm still have the same issue. I checked and treehouse_movie_db is bolded When I run the query, I get a little blue circle by the specific query but I'm not getting any errors or output.