[thelist] mysql table design

[Beau Hartshorne]

> I am creating a database table with phpMyAdmin.  For each column you
> have the option of labeling them "Primary" "Index" and "Unique".  From
> reading the MySQL manual, a primary key is a unique key that can't be
> null.  A unique key can have only distinct values.  So if I have a
> column, and I designate it primary, unique, and index, does that mean
> that I am being redundant.  If I label a column Primary, does it still
> get indexed?  Just need some clarification.  Thanks.

Yes.

Google is your friend (watch the wrap):

http://groups.google.ca/groups?&selm=20010318154903.B88458

Cheers,

Beau