is it possible to assign two primary key in a table
Answers were Sorted based on User's Feedback
Answer / sushma s
A table can have only one primary key assigned.
Is This Answer Correct ? | 19 Yes | 0 No |
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 |
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 |
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 |
Why are function needed?
What is the difference between the primary and unique key in mysql?
How to show table structure mysql?
can you tell how can you display the maximum salary in sql? : Mysql dba
What does tee command do in MySQL?
How large can a mysql database become?
What is data directory in mysql?
please give me the answer for this: query which generates the second highest integer in the table?
Can you tell how to find the number of rows in a resultset using php?
What does mysql flush tables do?
How do I edit a stored procedure in mysql?
How do I start mysql client?