is it possible to assign two primary key in a table

Categories >> Software >> Databases >> MySQL
Suggest New Category

Question Posted / pr

8 Answers
9840 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

is it possible to assign two primary key in a table ..

Answer / sushma s

A table can have only one primary key assigned.

Is This Answer Correct ?

19 Yes

0 No

is it possible to assign two primary key in a table ..

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

is it possible to assign two primary key in a table ..

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

is it possible to assign two primary key in a table ..

Answer / vignesh lakshmirajan

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

is it possible to assign two primary key in a table ..

Answer / guest

no it doesn't possible

Is This Answer Correct ?

3 Yes

0 No

is it possible to assign two primary key in a table ..

Answer / rajan

any if one time primary key in a table

Is This Answer Correct ?

0 Yes

0 No

is it possible to assign two primary key in a table ..

Answer / kunal

yes, it is called composite key

Is This Answer Correct ?

0 Yes

0 No

is it possible to assign two primary key in a table ..

Answer / rajan bajalia

yes

Is This Answer Correct ?

1 Yes

2 No

Post New Answer

More MySQL Interview Questions

List the different types of normalization?

0 Answers

Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

0 Answers

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

0 Answers

What is mysql common?

0 Answers

What is a text delimiter?

0 Answers

How to get the current date in mysql?

0 Answers

What is difference between mysql and mysql server?

0 Answers

change column name and make a unique column so we get no dupes.