how we can use more then one primary key in Single Table
Answers were Sorted based on User's Feedback
Answer / mukesh
Its impossible to create two primary key in a single table
but if we use composite key we have do it just like that
CREATE TABLE Test (id1 INT NOT NULL, id2 INT NOT NULL, name
CHAR(20) NOT NULL, PRIMARY KEY(id1,id2));
Is This Answer Correct ? | 14 Yes | 0 No |
Answer / sathishrpillai
A single table can't have two primary keys.it can only
forgein keys.but u can use any number of foregin key in a
single table.
Is This Answer Correct ? | 15 Yes | 7 No |
Answer / piyush
We can use more then one primary keys in a single table but
it is possible only in 2005. otherwise we can not use more
then one primary keys in a single table.
Is This Answer Correct ? | 10 Yes | 3 No |
Answer / frank
Can't, but can create primary key with multiple columns:
CREATE TABLE Test (id1 INT NOT NULL, id2 INT NOT NULL, name
CHAR(20) NOT NULL, PRIMARY KEY(id1,id2));
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / sharad
CREATE TABLE Test (id1 INT ,id2 INT , name CHAR(20) NOT
NULL, PRIMARY KEY(id1,id2));
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / naveen
with this query two primary keys are created but in the insertion time it doesn'y work automatically.it says it can't insert null value in id1.
CREATE TABLE Test (id1 INT NOT NULL, id2 INT NOT NULL, name
CHAR(20) NOT NULL, PRIMARY KEY(id1,id2));
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
How do I uninstall mysql connector?
How do you flush privileges?
Is mysql a scripting language?
What is database migration in mysql?
Is it possible to update a table value with out using update command?. if yes what is the reason, if no what is the reason?.
How do I start mysql in mysql workbench?
How to delete a database from mysql server.
using primary can we relate two table, with out foreign key?
Can anyone help me to create a good mysql database schema with an example. Thanks, Sekar.jr
What is pragma serially_reusable and why is it used?
Query to select passwords from a table having a column "Password" Whose length is b/w 8 &15 and having 'A' as the first character in the password irrespective of case.
What are the 3 main types of search queries?