Interested to Buy Any Domain ? << Click Here >> for more details...
how we can use more then one primary key in Single Table
- 9 Answers
- 16303 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
How do I rename a procedure?
What are the similarities between a function and a procedure?
How can you change the password of a mysql user?
How to convert character strings to dates?
Can I use mysql for free?
Where is the mysql data directory?
What is back end and front end?
How can you calculate the sum of any column of a table?
What is the password of mysql?
Give string types available for column?
How many primary keys can be there in a table?
What is procedures in mysql?
What is sqlyog?
How many sql dml commands are supported by 'mysql'?
How do I stop a mysql command?
