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

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.

Suggest An Answer

No suggestions avaliable!

Related Interview Questions