"joe collins" <[EMAIL PROTECTED]> wrote:
> does MySQL support composite keys?
Yes, MySQL supports composite keys:
http://www.mysql.com/doc/en/Multiple-column_indexes.html
>
> I have a table 'Group_Map'
>
> This has 3 fields
>
> contac
Hi,
does MySQL support composite keys?
I have a table 'Group_Map'
This has 3 fields
contact_id (primary key in another table)
group_id (candidate key in another table)
user_id (primary key in another table)
is it possible / advisable to create and maintain a composite key for
>From going over
http://www.mysql.com/doc/en/MySQL_indexes.html (again)
http://www.mysql.com/doc/en/Indexes.html (again)
And doing some experimentation it seems that when I build a compound
index (A key spanning multiple column) of column types
String, int, int - sorting the result takes a very
Note: forwarded message attached.
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com--- Begin Message ---
Hi All,
I have a database consisting of 2 tables.
patient_info ( Patient Information ).
Hi All,
I have a database consisting of 2 tables.
patient_info ( Patient Information ).Looks like
lastname VARCHAR(10)
fname VARCHAR(10)
ssno INT(9) PRIMARY KEY
IDINT(4) AUTO_INCREMENT
patientins_info ( PatientInsurance Information)
insco VARCHAR(10)
insid VARCHAR(10)
On Tue, 1 Apr 2003 20:30:32 -0800 (PST), Jinesh Varia used a few
recycled electrons to form:
| Hello group,
|
| I have a simple composite key
| create table a_b (aID int NOT NULL, bID int NOT NULL, primary key
| (aID,bID));
|
| Where aID is primary key in the table a and bID is the primary key in
Hello group,
I have a simple composite key
create table a_b (aID int NOT NULL, bID int NOT NULL, primary key
(aID,bID));
Where aID is primary key in the table a and bID is the primary key in table b,
While my primary keys are automatically indexed, I am having problems when I use the
bID.
I re
