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

Written By
clash between unique and index keys
February 08, 2006 12:58AM
February 08, 2006 04:40PM
February 08, 2006 05:44PM
February 08, 2006 05:49PM
February 09, 2006 12:04AM

Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.