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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Is mysql frontend or backend?

643


How can you retrieve a portion of any column value by using a select query?

648


How can we change the data type of a column of a table?

738


What are the differences between char and nchar?

708


Where is the mysql data directory?

671






How to find the unique values if the value in the column is repeated?

729


What are the steps involved in query processing?

630


What is meant by sharding?

663


How to get a version of mysql?

724


Is mysql query case sensitive?

687


What is mysqladmin flush hosts?

688


Can mysql function return a table?

805


What is an example of a delimiter?

673


Where is the myisam table stored?

688


How can you find out the version of the installed mysql?

929