At 14:12 -0500 12/20/02, Andrew Kuebler wrote:
I have the following table; I renamed the columns a & b for easy
reading:
ID INT(9) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
aID INT(9),
bID MEDIUMINT(7),
UNIQUE ab (aID, bID)
INDEX b(bID)
As far as I understand the UNIQUE INDEX also provides the index
I have the following table; I renamed the columns a & b for easy
reading:
ID INT(9) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
aID INT(9),
bID MEDIUMINT(7),
UNIQUE ab (aID, bID)
INDEX b(bID)
As far as I understand the UNIQUE INDEX also provides the index for aID,
but not bID. Is there any other way to
