MySQL Forums
Forum List  »  MySQL Workbench

Re: Error messages when trying to create table with foreign key
Posted by: Charles Iscove
Date: June 20, 2009 02:11PM

That worked, but I also had to add an index:

alter table Release add index (Type);

Now I'm getting the following warning:

PRIMARY and INDEX keys should not both be set for column `idType`

I made all the 'id' columns in the tables Primary. Should I make another column Primary - what if the table as a number of columns - how do I decide which one - or should I just remove the Primary key altogether?



Edited 1 time(s). Last edit at 06/22/2009 10:57AM by Charles Iscove.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Error messages when trying to create table with foreign key
1576
June 20, 2009 02:11PM


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.