[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