is it possible to assign two primary key in a table

Answers were Sorted based on User's Feedback



is it possible to assign two primary key in a table ..

Answer / sushma s

A table can have only one primary key assigned.

Is This Answer Correct ?    19 Yes 0 No

is it possible to assign two primary key in a table ..

Answer / sudipta santra

IF WE MAKE COMPOSITE PRIMIRAY KEY THEN ONLY MORE THAN ONE
COLUMNS WILL BE BIND UP.

Is This Answer Correct ?    11 Yes 1 No

is it possible to assign two primary key in a table ..

Answer / jd

At the end of the day a primary key is unique non null value
that the data is indexed upon.

Even if only one column can be explicitly defined as the PK.
It is possible to uniquely identify a row differently, by
creating a unique non null column that is indexed. It is
implicitly then a PK.

Is This Answer Correct ?    4 Yes 0 No

is it possible to assign two primary key in a table ..

Answer / vignesh lakshmirajan

Answer is strictly NO...!!!

we may have morethan one unique column in a table but we should assign only one primary key...!!

Is This Answer Correct ?    3 Yes 0 No

is it possible to assign two primary key in a table ..

Answer / guest

no it doesn't possible

Is This Answer Correct ?    3 Yes 0 No

is it possible to assign two primary key in a table ..

Answer / rajan

any if one time primary key in a table

Is This Answer Correct ?    0 Yes 0 No

is it possible to assign two primary key in a table ..

Answer / kunal

yes, it is called composite key

Is This Answer Correct ?    0 Yes 0 No

is it possible to assign two primary key in a table ..

Answer / rajan bajalia

yes

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More MySQL Interview Questions

Why are function needed?

0 Answers  


What is the difference between the primary and unique key in mysql?

0 Answers  


How to show table structure mysql?

0 Answers  


can you tell how can you display the maximum salary in sql? : Mysql dba

0 Answers  


What does tee command do in MySQL?

1 Answers  






How large can a mysql database become?

0 Answers  


What is data directory in mysql?

0 Answers  


please give me the answer for this: query which generates the second highest integer in the table?

8 Answers  


Can you tell how to find the number of rows in a resultset using php?

0 Answers  


What does mysql flush tables do?

0 Answers  


How do I edit a stored procedure in mysql?

0 Answers  


How do I start mysql client?

0 Answers  


Categories