Too big Select?!

[SZS]

I'm having problems with MySQL. I make a table (using MySQL Control Center..), put something in it, save and close, and when I want to return the rows it gives me this:

"Error 1104: The SELECT would examine more rows than MAX_JOIN_SIZE. Check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=..."

As long as the table is empty, it does return with success, but when I put something in it and then try, it gives me the error and refuses to return anything at all. Any ideas on how to fix this? I'm pretty new to MySQL, so bare with me.

[dotcomguy]

What is your database schema and the query you are trying to execute?

[SZS]

I'm using the MySQL Control Center for all of this. That's where I'm getting the error. With PHP it works fine.. I'm just wondering what's wrong with it. =)
My database is just a newly created test db.
The CC is simply trying to display all of the rows in the table when this error occurs.

[dotcomguy]

I thought you were asking about a query that you were running.

This sounds like a bug in the control center in that case. I haven't used it. I like the command line.

[SZS]

Fair enough. I'm not that advanced yet. =) For now I'll try PHPMyAdmin instead, a tip from another forum. Thanks for your assistance, though! =)

[dotcomguy]

You shouldn't have any trouble with phpmyadmin. I've used it before and it's very popular (more usage means less liklihood of bugs/problems). This isn't the first time I've heard of some kind of error with Mysql Control Center.