Export Data from multiple tables and Later export it to CSV
Export Data from multiple tables and Later export it to CSV
I have a dynamic script and I am trying to export product data on an e-commerce site.
Each product has a lots of attributes and each attribute goes to various tables some what eav design.
Now when I have a join query for each attribute.
When I put 120 attributes together and try to export it.
I get the following error.
Too many tables; MySQL can only use 61 tables in a join
And I searched and searched on google and yahoo nothing relevant found.
Seems like a well kept secret.
I see a lots of software's out there that claim to be able to do the above.
I am wondering what piece of the puzzle m I missing.
is there some other method to do the above ?
Can I break it down in chunks to honor the limit ?
Can I bypass the limit ?
Or should I give up !!!
Please advice.
Darsh.
Subject
Written By
Posted
Export Data from multiple tables and Later export it to CSV
November 05, 2009 08:19PM
November 06, 2009 04:43AM
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.