What is the difference between primary key and candidate key

  • Primary key in MySQL is use to identify every row of a table in unique manner. For one table there is only one primary key. One of the candidate keys is the primary key and the candidate keys can be used to reference the foreign keys.

Previous Papers

Model Tests

Current Affairs

Question Answers

Related Question & Answers

What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type

What are the disadvantages of MySQL

Is there an object oriented version of MySQL library functions?

What are the drivers in MySQL

What are the advantages of MySQL in comparison to Oracle?

Related Practice Tests

MySQL Interview Questions for Freshers
Categories
AndroidC programmingC++ programmingCloud ComputingComputerComputer System ArchitecureData BaseData StructureInternet & Social MediaJava programmingManual TestingMS OfficeMySQLNetworkingOperating SystemPHPProgrammingSoftware EngineeringSoftware Testing
What is the difference between primary key and candidate key
Home Ask Questions Study Current Affairs Previous Papers Kerala PSCIBPSUPSCRBITNPSCMPSCSSCCBSEUnited StatesModel Tests News More Answers Coaching Centres Careers Downloads Colleges