MySQL Forums
Forum List  »  Newbie

Export Data from multiple tables and Later export it to CSV
Posted by: Darshan Gajiwala
Date: November 05, 2009 08:19PM

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.

Options: ReplyQuote


Subject
Written By
Posted
Export Data from multiple tables and Later export it to CSV
November 05, 2009 08:19PM


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.