how we can use more then one primary key in Single Table

Answer Posted / sonu kumar

we can more than one primary key in a single table in case of self joining
eg:-if want to details of employee and their manager in same table than empid,mngid both treated as primary key

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many rows can be inserted in mysql at a time?

485


What does mysql_query return?

492


What is trigger in mysql?

482


How can I create database in mysql?

487


What are the different mysql database engines?

523






Is mysql a odbc?

463


What is the difference between myisam dynamic and myisam static in mysql?

489


How to delete a database from mysql server.

510


How do I create a stored procedure in mysql?

484


What is blob and clob?

500


how we will Show selected records sorted in an ascending (asc) or descending (desc).

537


How can you export the table as an xml file in mysql?

490


Does mysql use tcp or udp?

519


How to see the create table statement of an existing table?

568


What are the limitations of mysql?

496