Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What?s the difference between PRIMARY KEY and UNIQUE in
MyISAM?

Answers were Sorted based on User's Feedback



What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?..

Answer / amith

PRIMARY KEY cannot be null, so essentially PRIMARY KEY is
equivalent to UNIQUE NOT NULL

Is This Answer Correct ?    28 Yes 8 No

What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?..

Answer / raj

primary key is something which uniquely identifies the table
row. the value in primary key declared field can't be null
On the other hand unique avoids the duplicacy of data.

Is This Answer Correct ?    8 Yes 1 No

What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?..

Answer / niraj kumar

primary key is not accept the null value.primary key is
always autoincrement.unique key is accept the one null
value.it is not a autoincrement.

Is This Answer Correct ?    4 Yes 15 No

What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?..

Answer / manish

Primary Keys are used in building relationships between
tables in a database. (an index is automatically created on
the primary key). The difference between primary and
ordinary keys is that there can be multiple keys, but only
one primary key.

Is This Answer Correct ?    7 Yes 20 No

Post New Answer



More MySQL Interview Questions

What is foreign key in mysql?

0 Answers  


What is the difference between b-tree and hash indexes?

0 Answers  


Do while loop in mysql procedure?

0 Answers  


Can I use mysql for free?

0 Answers  


What is a select query?

0 Answers  






What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

0 Answers  


How do you backup a database in mysql?

0 Answers  


What is the default port for mysql and how it can change?

0 Answers  


Is SET Command is SQL Statement..?

4 Answers   BitWise,


What, if a table has one column defined as TIMESTAMP?

0 Answers  


Why we use mongodb instead of mysql?

0 Answers  


How does mysql clustering work?

0 Answers  






Categories