how we can use more then one primary key in Single Table
- 9 Answers
- 13384 Views
- Systematix, I also Faced
- E-Mail Answers
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
What is the difference between sql and mysql and oracle?
How to drop an existing view in mysql?
Where the database is stored in mysql?
What is row level locking?
Can we rollback truncate in mysql?
Is mysql server free?
How do I start mysql server?
Can foreign key have duplicate values?
How to escape special characters in sql statements?
How to delete a column and add a new column to database
What are the advantages of myisam over innodb?
How can you find out the version of the installed mysql?
How to check if value already exists in mysql database in php?
Where’s database data actually stored? Is there a way to see the files which are stored?
Is mysql a free database?
