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...


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 do I connect to mysql database?

0 Answers  


Can you tell the difference between $message and $$message?

0 Answers  


Which mysql function is used to concatenate string?

1 Answers  


How to use regular expression in pattern match conditions?

0 Answers  


How do I edit a database in mysql workbench?

0 Answers  


A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.

1 Answers  


What are date and time data types in mysql?

0 Answers  


Is mysql a free database?

0 Answers  


What is mysqlcommand?

0 Answers  


What are procedures in mysql? Explain

0 Answers  


How do you convert to a different table type?

1 Answers  


How can you change the name of any existing table by using the sql statement?

0 Answers  


Categories