Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


how we can use more then one primary key in Single Table

Answers were Sorted based on User's Feedback



how we can use more then one primary key in Single Table..

Answer / mukesh

Its impossible to create two primary key in a single table
but if we use composite key we have do it just like that

CREATE TABLE Test (id1 INT NOT NULL, id2 INT NOT NULL, name
CHAR(20) NOT NULL, PRIMARY KEY(id1,id2));

Is This Answer Correct ?    14 Yes 0 No

how we can use more then one primary key in Single Table..

Answer / sathishrpillai

A single table can't have two primary keys.it can only
forgein keys.but u can use any number of foregin key in a
single table.

Is This Answer Correct ?    15 Yes 7 No

how we can use more then one primary key in Single Table..

Answer / piyush

We can use more then one primary keys in a single table but
it is possible only in 2005. otherwise we can not use more
then one primary keys in a single table.

Is This Answer Correct ?    10 Yes 3 No

how we can use more then one primary key in Single Table..

Answer / frank

Can't, but can create primary key with multiple columns:

CREATE TABLE Test (id1 INT NOT NULL, id2 INT NOT NULL, name
CHAR(20) NOT NULL, PRIMARY KEY(id1,id2));

Is This Answer Correct ?    8 Yes 1 No

how we can use more then one primary key in Single Table..

Answer / sharad

CREATE TABLE Test (id1 INT ,id2 INT , name CHAR(20) NOT
NULL, PRIMARY KEY(id1,id2));

Is This Answer Correct ?    4 Yes 0 No

how we can use more then one primary key in Single Table..

Answer / naveen

with this query two primary keys are created but in the insertion time it doesn'y work automatically.it says it can't insert null value in id1.

CREATE TABLE Test (id1 INT NOT NULL, id2 INT NOT NULL, name
CHAR(20) NOT NULL, PRIMARY KEY(id1,id2));

Is This Answer Correct ?    3 Yes 0 No

how we can use more then one primary key in Single Table..

Answer / sonu kumar

we can more than one primary key in a single table in case of self joining
eg:-if want to details of employee and their manager in same table than empid,mngid both treated as primary key

Is This Answer Correct ?    0 Yes 0 No

how we can use more then one primary key in Single Table..

Answer / jemi

can't

Is This Answer Correct ?    8 Yes 9 No

how we can use more then one primary key in Single Table..

Answer / sriram

Can't

Is This Answer Correct ?    2 Yes 5 No

Post New Answer



More MySQL Interview Questions

What is procedural api?

0 Answers  


How can we get the number of rows affected by query?

0 Answers  


What is query log in mysql?

0 Answers  


What is horizontally scalable?

0 Answers  


What is blob storage?

0 Answers  






Which is best pdo or mysqli?

0 Answers  


How can you move the master database

0 Answers   IBM,


What can I do with mysql?

0 Answers  


How much does mysql cost?

0 Answers  


What are the different mysql database engines?

0 Answers  


Can varchar be primary key?

0 Answers  


I have two sql database at different PC.how can link b/w database and database tables.

2 Answers  






Categories