What is the diff. bwt. primary key and unique key?
Answers were Sorted based on User's Feedback
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 |
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 |
primary is not allow null value.but unique can be allow null
value
Is This Answer Correct ? | 3 Yes | 0 No |
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 |
Is there an object-oriented version of MySQL library functions?
What mysql means?
What are queries used for?
How can you calculate the sum of any column of a table?
Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools?
Why do we need mysql?
How do I start mysql database?
What are programming functions?
What are the two types of queries?
What is the purpose of mysql database?
Difference between CHAR and VARCHAR?
What does mysqli stand for?