is it possible to assign two primary key in a table

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What language does mysql use?

436


What is mysql server used for?

485


Is mysqli faster than mysql?

491


What is mvcc in mysql?

534


How does limit work in mysql?

473






How do I restart mysql on windows?

481


Write a query to select all teams that won either 1, 3, 5 or 7 games.

822


How to print message in mysql trigger?

1004


How to calculate the difference between two dates?

486


What is data directory in mysql?

485


What is the limit of mysql database?

495


What does blob mean in mysql?

494


What is procedures in mysql?

512


How do I remove a user from mysql?

562


What is a string in mysql?

469