MySQL Forums :: InnoDB :: Error while creating the table in InnoDB


Advanced Search

Error while creating the table in InnoDB
Posted by: krishna reddy ()
Date: May 07, 2010 12:05AM

Hi,

I am getting the following error while creating the table with more than 70 foreign keys.can u please suggest how to create the table with more than 64 foreign keys.

Is there any way to increase the No of keys?I am using the My SQL 5.5 version.
I am migrating the database from Oracle to My SQL.one of my table in Oracle schema having the 100 foreign keys.I need to use the same table structure with 100 foreign keys.



Edited 1 time(s). Last edit at 05/07/2010 12:06AM by krishna reddy.

Options: ReplyQuote


Subject Views Written By Posted
Error while creating the table in InnoDB 1665 krishna reddy 05/07/2010 12:05AM
Re: Error while creating the table in InnoDB 853 Rick James 05/08/2010 09:30AM


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.