Explain the difference between primary key and candidate key in Mysql?
Primary Key: It is a column that uniquely identifies a record. In Mysql, only one candidate key can behave like Primary Key.
Candidate Key: It can be any column that can qualify as 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.