[Cialug] mysql index/unique

Nathan C. Smith smith at ipmvs.com
Thu Nov 9 11:52:36 CST 2006


Isn't there a unique index option, like create index require unique, or
something like that?



> -----Original Message-----
> From: Barry Von Ahsen [mailto:barry at vonahsen.com] 
> Sent: Thursday, November 09, 2006 11:47 AM
> To: Central Iowa Linux Group
> Subject: [Cialug] mysql index/unique
> 
> 
> 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
> 
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
> 


More information about the Cialug mailing list