how we can use more then one primary key in Single Table
Answer Posted / 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 |
Post New Answer View All Answers
How to delete a database from mysql server.
What is the current version of mysql?
How do I insert an image into mysql workbench?
What does mysql_query return?
Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba
What is an index? How can an index be declared in mysql?
What is insert query in mysql?
What is difference between unix timestamp and mysql timestamp?
How do I view mysql logs?
What is the difference between float and double?
how can you test for null values in a database? : Mysql dba
How to enter numeric values as hex numbers?
What is bigint in mysql?
Can we store files in mysql?
What is pdo mysql?