Difference between primary and unique keys in mysql:
You can only have one primary key per table, but multiple unique keys.
Similarly, a primary key column doesn't accept null values, while unique
key columns can contain one null value each. And finally, the primary key
column has a unique clustered index while a unique key column has a
unique non-clustered index