Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

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

Question Posted / sandhirasegaran

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 insert query in mysql?

0 Answers  

Is mysql good for large database?

0 Answers  

What is the difference between truncate and delete?

0 Answers   DELL,

What is index length in mysql?

0 Answers  

What is dblink?

0 Answers  

What can you do with mysql?

0 Answers  

If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?

0 Answers  

Why does mysql have so many connections?

0 Answers  

1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?

0 Answers   ACC,

Explain advantages of InnoDB over MyISAM?

1 Answers  

What is a left join mysql?

0 Answers  

How do I insert multiple rows in a table?

0 Answers  

For more MySQL Interview Questions Click Here
Categories