Question: what is the difference between primary key and index in mysql?
Answer: Primary key does not allow NULL values, but unique key allows NULL values. ... You can have more than 1 unique key table column (unlike primary key which means only 1 table column in the table is unique). INDEX also creates uniqueness. MySQL (example) will create a indexing table for the column that is indexed.