MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Too many tables; MySQL can only use 61 tables in a join
Posted by: Keith Larson
Date: April 22, 2014 07:10PM

Yes the limit is 61
http://dev.mysql.com/doc/refman/5.6/en/joins-limits.html

Not sure what version you are using but it has had this limit for some time
http://dev.mysql.com/doc/refman/4.1/en/joins-limits.html

How optimized is your query if you are joining that many tables?

Can you use a View to gather some data for you a little better then reference that?

Just trying to help....

http://anothermysqldba.blogspot.com

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Too many tables; MySQL can only use 61 tables in a join
Vishal Gandhi
April 22, 2014 04:14PM
Re: Too many tables; MySQL can only use 61 tables in a join
Keith Larson
April 22, 2014 07:10PM
Re: Too many tables; MySQL can only use 61 tables in a join
Rick James
April 22, 2014 07:52PM
Re: Too many tables; MySQL can only use 61 tables in a join
Phillip Ward
April 23, 2014 05:53AM
Re: Too many tables; MySQL can only use 61 tables in a join
Rick James
April 23, 2014 11:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.