BTW Carlos,
I'm not sure why you would want or need two primary
keys in a table, but if find you truly do (as opposed
to a PK and some other unique index/key) - there is
probably something wrong with your database design.
You may need to rethink your design. Do some research
and reading on the topics of "Database Design" and
"Database Normalization" - that may help.
I know when I first started in Databases (especially
in designing them), I had some major misconceptions as
to what a PK was and how it should be used. The
O'Reilly's book "Managing and Using MySQL, 2nd
Edition" has a good chapter on the topics. So does
"Mastering MySQL 4". But keep in mind these are only
*basic* tutorials and high-level coverage of the
subject. Also cheek out Paul DuBois' book "MySQL, 2nd
Edition". While, if my memory serves me correctly, he
does not have a specific chapter on DB design or
normalization, he does teach good design concepts as
you progress through the book and its examples; and
for anything else MySQL related, it is, IMHO, the best
book out there.
Good luck,
Mark
--- Mark V <news4mark@stripped> wrote:
> Hi Carlos,
>
> You can't have 2 primary keys. A table can only have
> one primary key. You can, however, also define a
> Unique key, and if you set it up such that it is not
> null, it will act much like a prmary key:
>
> CREATE TABLE test
> ( id1 INT UNSIGNED NOT NULL,
> PRIMARY KEY (id1),
> id2 INT UNSIGNED NOT NULL,
> UNIQUE KEY (id2),
> data VARCHAR(25)
> );
>
> Hope that helps,
> Mark
>
> --- Carlos Vazquez <Carlos@stripped> wrote:
> > Hi all!
> >
> > Just wanted to know how do I create a table with
> two
> > primary keys.
> >
> > Thanks a lot!
> >
> >
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
