What is the candidate key in Mysql?

Sharad Jaiswal
Sharad Jaiswal

Posted On: Feb 22, 2018

 

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.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Mysql Interview Questions

    What is MySql ?

    MySql is a multi-threading, multi-user open source SQL database management system . It is typically used for web applica..

    Mysql Interview Questions

    In which language MYSQL it is written ?

    MySql is written in C and C++ programming and SQL parser written in yacc...