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 the function of mysqldump?

570


What is the difference between float and double?

587


How do I find mysql database?

482


Is mysql relational database?

471


What is clob in mysql

483






Is mysql from oracle?

499


Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

2416


What ascii 31?

520


Is mysqli secure?

480


What is mysql vs sql?

483


What is the default password for mysql?

460


How do I select a database in mysql?

491


Is mysql port 3306 tcp or udp?

512


How do you insert a table?

500


How can you create and drop view in mysql?

505