Has my unique index been set?

alexstan

New Member
I'm trying set a composite unique index made of 2 fields using:\[code\]ALTER TABLE mytable ADD UNIQUE INDEX(location,duplicate_count)\[/code\]when I check under indexes in phpmyadmin I see:\[code\]Keyname Type Unique Packed Column Cardinality Collation Null CommentPRIMARY BTREE Yes No id 1 A No location BTREE Yes No location 1 A Yes duplicate_count1 A Yes\[/code\]So it looks like ( If I understand correctly ) that there is 1 index, a composite index called location made of 2 fields ( location and duplicate_count ). If this is correct that is what I am trying to do. Does my explanation seem correct?thanks in advance,Bill
 
Back
Top