Interested to Buy Any Domain ? << Click Here >> for more details...
how we can use more then one primary key in Single Table
- 9 Answers
- 15683 Views
- Systematix, I also Faced
- E-Mail Answers
Answer Posted / naveen
with this query two primary keys are created but in the insertion time it doesn'y work automatically.it says it can't insert null value in id1.
CREATE TABLE Test (id1 INT NOT NULL, id2 INT NOT NULL, name
CHAR(20) NOT NULL, PRIMARY KEY(id1,id2));
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Write a query to find duplicate rows in table?
Explain what is mysql?
Differentiate CHAR_LENGTH and LENGTH?
How do I edit a table in mysql workbench?
What is join in mysql? What are the different types of join?
Is mariadb faster than mysql?
How To see all the tables from a database of mysql server.
How do I install mysql workbench?
What is mysql root?
What is blob and text in mysql?
Is number a datatype in mysql?
What is mysql community edition?
What are the limitations of mysql?
What is myisamchk?
What is regexp?
