SQL

mysql primary vs unique

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