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

How many sql dml commands are supported by 'mysql'?

0 Answers  


How to drop an existing view in mysql?

0 Answers  


What storage engines are used in MySQL?

0 Answers  


change column name and make a unique column so we get no dupes.

0 Answers  


Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

0 Answers  






How to calculate the difference between two time values?

0 Answers  


What is index length in mysql?

0 Answers  


what is the Dynamic management views? where can you use?

1 Answers   ACC,


What's the difference between mysql and sql server?

0 Answers  


How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

0 Answers  


How can increase the performance of MySQL select query?

3 Answers   RV Technologies, Span Systems,


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

7 Answers  


Categories