MySQL Forums
Forum List  »  InnoDB

Re: Error With Multiple Foreign Keys in a Table
Posted by: KimSeong Loh
Date: April 14, 2005 07:59PM

As the error message told you, you need to have an index those columns before you can create a foreign key, some newer version have this restrictions removed, can't recall which version.

so, you need to first create the follwing 2 index before creating the foreign key constraint
(`call_type_id`) in table gc_call_info
and
(`call_type_id`) in table call_type_list

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Error With Multiple Foreign Keys in a Table
2148
April 14, 2005 07:59PM


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.