Explain the difference between primary key and candidate key in Mysql?

Answer»

Primary Key	CANDIDATE Key
It is a column that uniquely identifies a record. In Mysql, only one candidate key can behave LIKE Primary Key.	It can be any column that can QUALIFY as a unique key in the database. In MySQL, there can be MULTIPLE candidate KEYS in one table. Each candidate key can behave like as a primary key.

Discussion