Interested to Buy Any Domain ? << Click Here >> for more details...
how we can use more then one primary key in Single Table
- 9 Answers
- 15934 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 now() and current_date()?
How do I enable mysqli extension?
How to create a table?
What are the advantages and disadvantages of using mysql?
Is mysql a nosql database?
How can we convert between Unix & MySQL timestamps?
How many rows mysql can handle?
How to present a past time in hours, minutes and seconds?
How do I rename a table in mysql?
What is the storage engine for mysql?
What are the differences between innodb and myisam engines?
How can you change the password of a mysql user?
Which software is used for mysql?
Is mysql written in c?
Write a query to display current date and time?
