MySQL Forums
Forum List  »  Optimizer & Parser

clash between unique and index keys
Posted by: Kenneth Vogt
Date: February 08, 2006 12:58AM

phpmyadmin reports the following to me about a certain table:

UNIQUE and INDEX keys should not both be set for column `field1`

(I know, phpmyadmin isn't a product supported by this forum, I am just referencing where I learned I had a problem.)

Let's call my unique key U_key and my index key I_key. U_key is made up of field1, field2, field3. I_key is made up of field1, field4, field5. Presume there are queries that require each of these keys. Also presume that U_key must be an unique key and I_key cannot be an unique key. How do I resolve the conflict between the keys?

Options: ReplyQuote


Subject
Views
Written By
Posted
clash between unique and index keys
5576
February 08, 2006 12:58AM
2531
February 08, 2006 04:40PM
2320
February 08, 2006 05:44PM
2462
February 08, 2006 05:49PM
2291
February 09, 2006 12:04AM


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.