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

What is the difference between mysql_fetch_array() and ysql_fetch_object() ?

509


What is the difference between database and table?

574


Can you tell few best practices to be followed for optimization in sql?

506


How does mysql store data?

523


How do I copy a table in mysql workbench?

456






how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.

512


How can you increase the performance of mysql select query?

487


How do I edit a trigger in mysql?

488


What is tee command in mysql?

487


Does mysql use t sql?

578


How do I create a schema in mysql?

475


Which statement is used to delete a table in MySQL.

483


how to connect a php script with the mysql database?

550


Can I copy mysql data directory?

494


What is longblob in mysql?

528