Interested to Buy Any Domain ? << Click Here >> for more details...
how we can use more then one primary key in Single Table
- 9 Answers
- 16037 Views
- Systematix, I also Faced
- E-Mail Answers
Answer Posted / frank
Can't, but can create primary key with multiple columns:
CREATE TABLE Test (id1 INT NOT NULL, id2 INT NOT NULL, name
CHAR(20) NOT NULL, PRIMARY KEY(id1,id2));
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Is mysql a server or database?
What is processlist in mysql?
How can you move the master database
What is data type for image in mysql?
Which statement is used in a select query for partial matching?
What is mysql optimization?
Is mysql case-sensitive?
How are mysql timestamps seen to a user?
Is mongodb faster than mysql?
What is InnoDB?
Write a command with which mysql table can be repaired
What does the file with the extension: frm, myd, and myi contain?
What is the purpose of using a heap table?
What is strict mode in mysql?
How many rows can a mysql table hold?
