news <[EMAIL PROTECTED]> wrote on 04/06/2006 09:39:33 AM: > IF I have a table like this: > id int not null, > field2 int not null, > ......, > primary key (id), > key (field2) > ) ENGINE=MyISAM; > > The primary key is id only or (id, field2)? > If this is the case which constraint are aplied on field2? > -- > Three words describe our society:homo homini lupus >
You declared that the primary key is only on the field (ID). There are no other fields involved. You also declared that the engine should create and maintain a separate index on the field (field2). There are no contstraints built into a "regular" index. Does that help? Shawn Green Database Administrator Unimin Corporation - Spruce Pine