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.
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.
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.