MySQL Forums
Forum List  »  Merge Storage Engine

Union Restrction
Posted by: Korey Fort
Date: February 13, 2008 02:40PM

I am attempting to create a merge table with 84 sub tables. I read there is a restriction of 61 tables allowed in a union/join. How do I bypass that limit, I have seen others with claims of up to 500 sub tables in a merge!

Thanks in advance

I think I may be mistaken. The 61 table limit is only on joins:
http://dev.mysql.com/doc/refman/5.1/en/joins-limits.html



Edited 1 time(s). Last edit at 02/13/2008 03:53PM by Korey Fort.

Options: ReplyQuote


Subject
Views
Written By
Posted
Union Restrction
9131
February 13, 2008 02:40PM


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.