MySQL Lists: mysql: No. of tables in JOIN

List:	General Discussion	« Previous Message Next 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 JOIN	Peter WR	27 Apr
• No. of tables in JOIN	Michael Widenius	27 Apr