Hi guys,
I'm new to MySQL, it's been just few days since I've installed it and started playing
with it.
I'm migrating web application from another database which gives us too many problems.
So far I've
successfully moved the structure and data across and running field tests.
What surprised me a
Hello,
I get the following error message: Too many tables. MySQL can only use 31
tables in a join
(tested on MySQL 4.0.1-alpha-log and MySQL 3.23.49a-log)
Is there a way I can use more then 31 tables in a join (setting a server
variable) ?
Thanks
Han
Is there any way that this number could be increased
by changing any of the variables in the configure file
or is this an internal limitation?
I've seen a similar behaviour on SQLServer but that
was on a prior version and is supposed to have been
fixed on later versions.
I'm using one table tha