is it possible to set 2 primary keys in a sql table?pls help fastly?

Answer 1

No.

But u may use two or more "super key" instade. or can create a primary key using two or more fields (combined)

Answer 2

No u cant set 2 primary keys in a table ,but set it as candidate key.
U can set 2 fields together to be unique ,by setting the unique index on them together. And ofcourse not null on each individually!

Answer 3

short answer NO.

You also may only have one autonumber key.

You may want to use an auotnumber key for tracking purposes then cluster another key.

clustering the key will arrange it on the disk in that order. This is generally where you can pick up some speed.

Answer 4

You didn't mention what brand of sql - MySQL? MSSQL? Mostly you just use one primary key and then use unique indexed columns. Read the thread in the link below it should point you in the right direction.

Answer 5

yes it is possible.......u can do it by making a grp of keys ur primary key..this is called composite key

Answer 6

its not possible, we can set up only composite primary key.

Answer 7

Yes. This will set grp and id to primary keys.

CREATE TABLE animals (
grp ENUM('fish','mammal','bird') NOT NULL,
id MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (grp,id)
);