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

Use mysqldump to create a copy of the database?

2 Answers  


How we can copy one table data into another table whose name same as table but in differ database

8 Answers  


Explain multi-version concurrency control in MySQL?

2 Answers  


Explain MySQL optimization?

1 Answers  


how fastest access of data can be done from database ?

3 Answers  






How can you plan the logshipping before processing?

0 Answers   ACC,


How do you start MySQL on Linux?

5 Answers   Cybernet,


what is collation? how many types of installations in sql server?

3 Answers  


What is diff b/w MYISAM and INNODB storage engine. and also define the benifits and drawbacks of both storage engine

1 Answers  


How can increase the performance of MySQL select query?

3 Answers   Span Systems, RV Technologies,


I have two sql database at different PC.how can link b/w database and database tables.

2 Answers  


How can we change the name of a column of a table?

7 Answers  






Categories