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...

is it possible to assign two primary key in a table

Answer Posted / jd

At the end of the day a primary key is unique non null value
that the data is indexed upon.

Even if only one column can be explicitly defined as the PK.
It is possible to uniquely identify a row differently, by
creating a unique non null column that is indexed. It is
implicitly then a PK.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is acid in mysql?

805


What is the storage engine for mysql?

904


How can you import tables from a sql file into a database by using the mysql client?

965


What is mysql community edition?

885


How to extract a unit value from a date and time?

895


How can you plan the logshipping before processing?

2270


What is trigger in mysql with example?

864


How do I download mysql on my laptop?

824


How to Set a root password if there is on root password.

1020


How do you rename a table in mysql?

952


What are the different column comparison operators in mysql?

886


How to write optimized query in mysql?

940


What is mysql and mysqli?

872


What do you understand by mysql terminal?

984


What is a transaction? Describe mysql transaction properties.

1035