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

what is the advantage of left outer join?

2 Answers  


how many ways we can get the current date in mysql?

2 Answers  


maximum size of a database in mysql?

2 Answers  


which version of mysql can't support stored procedure??

3 Answers  


Explain the architecture models of SQL Server?

0 Answers  






How do you start and stop MySQL on Windows?

3 Answers  


how do i list constraints in my database by using sql server2000?

1 Answers  


what is the advantage of stored procedures, triggers and indexing in mysql

1 Answers  


How can you plan the logshipping before processing?

0 Answers   ACC,


if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?

2 Answers  


Give the syntax of GRANT commands?

3 Answers  


If you specify the data type as DECIMAL (5,2), what?s the range of values that can go in this table?

2 Answers  






Categories