Re: composite Keys

2004-03-16 Thread Egor Egorov
"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 > > contact_id (primary key in another table) > group_id (candi

Re: composite keys indexing

2003-04-01 Thread Michael Brunson
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