Interested to Buy Any Domain ? << Click Here >> for more details...
how we can use more then one primary key in Single Table
- 9 Answers
- 15681 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 maximum table size in mysql?
How do I restart mysql on windows?
Explain csv tables.
What is new mysqli?
How to dump one database for backup.
What is a storage engine? What are the differences between innodb and myisam engines?
What is difference between oracle sql and mysql?
What is the query to display top 20 rows?
What are the differences between mysql vs sql server?
What language is mysql written in?
How do I install mysql?
Can we use mysql and mysqli together?
How does mysql store data?
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
What is regexp?
