What is the diff. bwt. primary key and unique key?

Answers were Sorted based on User's Feedback



What is the diff. bwt. primary key and unique key?..

Answer / janhvee

diff. between primary key and unique is unique key can be
null but primary key can't be null.

one table can have only one primary key but unique key can
be multiple keys

Is This Answer Correct ?    17 Yes 0 No

What is the diff. bwt. primary key and unique key?..

Answer / rakesh ranjan

IN PRIMARY KEY IS ONLY IN ANY TABLE BUT WHEN WE TALKING
ABOUT UNIQUE KEY, IT CAN BE NULL.

Is This Answer Correct ?    5 Yes 1 No

What is the diff. bwt. primary key and unique key?..

Answer / jeyaprakash

primary is not allow null value.but unique can be allow null
value

Is This Answer Correct ?    3 Yes 0 No

What is the diff. bwt. primary key and unique key?..

Answer / sonu kumar

primary of any table can't be null but unique can be
primary key may be a unique key but unique can't be a primary key b/c primary key of any relation cant be a null value

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

Is there an object-oriented version of MySQL library functions?

1 Answers  


What mysql means?

0 Answers  


What are queries used for?

0 Answers  


How can you calculate the sum of any column of a table?

0 Answers  


Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools?

1 Answers   TCS,






Why do we need mysql?

0 Answers  


How do I start mysql database?

0 Answers  


What are programming functions?

0 Answers  


What are the two types of queries?

0 Answers  


What is the purpose of mysql database?

0 Answers  


Difference between CHAR and VARCHAR?

0 Answers  


What does mysqli stand for?

0 Answers  


Categories