[Cialug] mysql index/unique
Barry Von Ahsen
barry at vonahsen.com
Thu Nov 9 11:46:33 CST 2006
when I try to make a column unique then index it in phpMyAdmin, it does
it, but complains that you shouldn't use unique and index on the same
field. I've checked the mysql manual for indexes[1], and it doesn't say
anything good or bad (but it doesn't say much at all).
is this bad/good/indifferent? does unique imply index?
this is for mysql 4.1
-barry
[1] http://dev.mysql.com/doc/refman/4.1/en/mysql-indexes.html
More information about the Cialug
mailing list