Interested to Buy Any Domain ? << Click Here >> for more details...
how we can use more then one primary key in Single Table
- 9 Answers
- 16338 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 to Set a root password if there is on root password.
What is the difference between a database and a table?
How many rows can be inserted in mysql at a time?
What is difference between unix timestamp and mysql timestamp?
What is 'mysqld'?
How is myisam table stored?
Is mysql an oracle product?
What is a data directory?
How do I free up space in mysql?
What is regex in mysql?
Is mysql still relevant?
Can not connect to mysql server 10060?
What is localhost in mysql?
Why do we use views instead of tables?
What is a string in mysql?
