Too many tables. MySQL can only use 31 tables in a join

2004-03-09 Thread Victor Star
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

Too many tables. MySQL can only use 31 tables in a join

2002-05-13 Thread Han Leenders
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

error 1116:Too many tables. MySQL can only use 31 tables in a join

2001-12-19 Thread Christian E
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