clash between unique and index keys
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?
Subject
Views
Written By
Posted
clash between unique and index keys
6002
February 08, 2006 12:58AM
2753
February 08, 2006 04:40PM
2507
February 08, 2006 05:44PM
2667
February 08, 2006 05:49PM
2468
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.