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 |
what is constraints?
How to convert dates to character strings?
Why is it called mysql?
Can not connect to mysql server 10060?
How do you shutdown a mysql database?
What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?
What is mysql server used for?
How do you flush privileges?
How to execute mysql query in php?
How to get the number of rows selected or affected by a sql statement?
How do I import database through command line?
What is the command used to create a database using php and mysql?