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 is triggers?

693


How do I start mysql in mysql workbench?

669


What are the steps required to view your mysql database?

821


Write a query to fetch duplicate records from a table using mysql?

685


How do I rename a mysql database?

674


What are programming functions?

645


What is mysqli_num?

686


Which is better mysql or microsoft sql?

603


What is the difference between mysql and oracle?

710


How to drop an existing view in mysql?

700


How to list or view all databases from the mysql server.

721


What language is mysql written in?

695


What is data type for image in mysql?

633


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

737


What does mysql_fetch_assoc do?

689