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.|
BY Best Interview Question ON 20 Sep 2022