List:General Discussion« Previous MessageNext Message »
From:Peter Zaitsev Date:February 10 2004 7:20pm
Subject:Re: Maximum tables in a join (4.0.x)
View as plain text  
On Tue, 2004-02-10 at 07:47, Dan Nelson wrote:
> In the last episode (Feb 10), Andrew Loughe said:
> > What is the maximum number of tables allowed in a join for MySQL
> > 4.0.x?
> 
> It's not in the docs as far as I can see, but the feature comparison
> page says 31: http://www.mysql.com/information/crash-me.php?res_id=49 ,
> search for "tables in join".

One can get 63 by Recompiling MySQL if it helps. 



-- 
Peter Zaitsev, Senior Support Engineer
MySQL AB, www.mysql.com

Meet the MySQL Team at User Conference 2004! (April 14-16, Orlando,FL)
  http://www.mysql.com/uc2004/

Thread
Maximum tables in a join (4.0.x)Andrew Loughe10 Feb
  • Re: Maximum tables in a join (4.0.x)Dan Nelson10 Feb
    • Re: Maximum tables in a join (4.0.x)Peter Zaitsev10 Feb