4 fields to form key

Hi Is it possible to use 2 or more fields to become the primary key. I have a table CREATE TABLE tmptraining ( rowid int(10) unsigned NOT NULL auto_increment, sid char(32) NOT NULL default '', expiry date NOT NULL default '-00-00', arenaid tinyint(1) unsigned NOT NULL default '0',

Re: 4 fields to form key

I am not sure about the primary key. You can create a UNIQUE index on (field1, field2, field3, field4)... (I have done this) This will prevent any duplicate rows from being inserted. Hope it Helps, -Jason Garber Lead Programmer - pulseaday.com At 08:07 AM 8/23/2001 -0400, you wrote: Hi Is

Re: 4 fields to form key

Tim Cowan wrote: Hi Is it possible to use 2 or more fields to become the primary key. I have a table Yes CREATE TABLE tmptraining ( rowid int(10) unsigned NOT NULL auto_increment, sid char(32) NOT NULL default '', expiry date NOT NULL default '-00-00', arenaid

RE: 4 fields to form key

On 23-Aug-2001 Tim Cowan wrote: Hi Is it possible to use 2 or more fields to become the primary key. I have a table CREATE TABLE tmptraining ( rowid int(10) unsigned NOT NULL auto_increment, sid char(32) NOT NULL default '', expiry date NOT NULL default '-00-00', arenaid