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
What is procedures in mysql?
What is default password for mysql?
How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
What are the applications required to support mysql?
How do I start mysql in linux?
What are the 'mysql' command line arguments?
Explain the architecture models of SQL Server?
Does mysql use tcp or udp?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
What is database migration in mysql?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
How do I select a database in mysql workbench?
How do I rename a table in mysql?
How to delete an existing column in a table?
How do I backup mysql database on linux?