Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Does mysql use t sql?

1026


How is data stored in mysql?

976


I want to find out all databases starting with ‘test’, I have access to?

1200


How to use like conditions?

1039


Where MyISAM table will be stored and also give their formats of storage?

1110


How will you export tables as an xml file in mysql?

969


Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba

1072


What is a session in mysql?

1016


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

1027


Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

1053


What is mysql root?

999


What is MySQL?

1051


What is key in mysql?

951


What's the latest version of mysql?

1019


What is sqlyog?

1081