Question: what is the difference between index and primary key in mysql?
Answer: You can only have 1 primary key in a database table. ... 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.