What is the candidate key in Mysql?

In MySQL, a candidate key can be any column or a combination of columns that can qualify as a unique key in the database. There can be multiple candidate keys in one table. Each candidate key can qualify as the primary key. Candidate keys can take null values whereas primary keys can never be null.