Hi There,
i want to create a table (mytable) with three fields:
sid varchar(255)
id int
type int
However I want the 'id' field to be unique... I don't want it to by the primary key though. How do I use the "UNIQUE" command to get this to happen?
Basically the same SID can enter many 'ids' into the table - but each 'id' must be different. Different SIDs can enter the same 'ids'.
Thanks!
i want to create a table (mytable) with three fields:
sid varchar(255)
id int
type int
However I want the 'id' field to be unique... I don't want it to by the primary key though. How do I use the "UNIQUE" command to get this to happen?
Basically the same SID can enter many 'ids' into the table - but each 'id' must be different. Different SIDs can enter the same 'ids'.
Thanks!