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

Write a query to count the number of rows of a table in mysql.

472


What is difference between oracle and mysql?

486


How can you take the backup and restore a mysql database using php?

469


What port is mysql running on?

467


Is mysql relational database?

466






What are the other commands to know the structure of a table using mysql commands except explain command?

536


What is foreign key in mysql?

591


What is mysql database used for?

478


What are the three types of queries?

452


What is definer in mysql trigger?

490


How can I create database in mysql?

489


Is mysql still popular?

480


What is full form of xampp?

535


How do I setup mysql?

484


What is int unsigned?

489