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 check constraint?

3 Answers  


How to write query to select word java's from column employees and from emp table

1 Answers   CGI,


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

4 Answers  


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

2 Answers  


How to enable or disable a row of a table using MySQL in struts?

0 Answers  






SQL: 1. Write a queryto retrieve the author who was published a book at the youngest age? 2. write a query to retrieve the no. of books published a each year in various languages? 3. write a query to retrieve no. of books published by them only those authors who have published more than 1 book? 4. write a query to retrieve who has not published any books during the year 2006? 5. write a query to retrieve the authors who has published any books during the birth date write this query in 2 ways 1)joins 2)sub query 6. write a query to retrieve all the books which was published during jan 2007 & title containing India or published in the language hindi? 1. table name is liberary managemnt and two column is there one is authors and another one is books . 2.four fields will comes under authours like nationality, birthdate ,first-language,second-language 3.four fields will comes under books like authour,title ,language,publish date to write query using this details

4 Answers   Covansys,


Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

3 Answers   TCS,


what programming language which is used for testing and developement in sql?

3 Answers  


is it possible to assign two primary key in a table

8 Answers   IBM,


how many fields can be updated using set in a mysql query?

1 Answers  


why we are join a tow table

1 Answers  


What are the critical issues you have resolved in your company

0 Answers   Wipro,






Categories