List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:April 27 1999 8:58am
Subject:No. of tables in JOIN
View as plain text  
>>>>> "Peter" == Peter WR <pwr@stripped> writes:

Peter> Hi,
Peter> Is there any MySQL limitations to number of different tables in a JOIN
Peter> statement ?

Peter> There might be some practical, but that's another issue.

The internal limit is 32 (as shown in
http://www.mysql.com/crash-me-choose.htmy).  This limit may be increased to 
64 by changing one typedef.

Regards,
Monty
Thread
No. of tables in JOINPeter WR27 Apr
  • No. of tables in JOINMichael Widenius27 Apr