Question

What is the difference between MySQL PRIMARY KEY and UNIQUE constraint?

Answer 1

Answer:

The difference between a UNIQUE constraint and a Primary Key is that per table you may only have one Primary Key but you may define more than one UNIQUE constraints. Primary Key constraints are not nullable. UNIQUE constraints may be nullable. ... A UNIQUE constraint will generate a unique NON-CLUSTERED INDEX.

Explanation:

Hope it helps you