@lists.mysql.com
Subject: Re: Table with multiple primary keys - How
It is not possible to have more than one PRIMARY
key per table.
Maybe you need to use one PRIMARY key as the main index into
the table, then use UNIQUE or KEY which is a synonym for
INDEX on the other two columns.
This book will
It is not possible to have more than one PRIMARY
key per table.
Maybe you need to use one PRIMARY key as the main index into
the table, then use UNIQUE or KEY which is a synonym for
INDEX on the other two columns.
This book will help you ALOT with designing tables.
It will also teach you how
- Original Message -
From: "fbsd_user" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, March 07, 2006 11:40 PM
Subject: Table with multiple primary keys - How
What I am trying to do here is have 3 separate primary keys.
Creating a mysql select on either of the Logon_id
In the last episode (Mar 07), fbsd_user said:
> What I am trying to do here is have 3 separate primary keys. Creating
> a mysql select on either of the Logon_id, email_addr, or last_name
> fields will do a single read to the matching value. Like having 3
> different indexes into the same table.
C
What I am trying to do here is have 3 separate primary keys.
Creating a mysql select on either of the Logon_id, email_addr,
or last_name fields will do a single read to the matching value.
Like having 3 different indexes into the same table.
I don't want those 3 field concatenated together as a
