[thelist] mysql table design
Beau Hartshorne
beau at members.evolt.org
Mon Sep 16 12:37:00 CDT 2002
> 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%40yahoo-inc.co
m
Cheers,
Beau
More information about the thelist
mailing list