Interested to Buy Any Domain ? << Click Here >> for more details...
how we can use more then one primary key in Single Table
- 9 Answers
- 16318 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
What is a string in mysql?
How can we find out which auto increment was assigned on Last insert?
How can you see all indexes defined for a table?
How do I drop a database in mysql?
Which storage engine is best in mysql?
Does uninstalling mysql delete database?
What is int mysql?
What is the latest mysql?
What is schema in mysql?
What is identity in mysql?
Write a query to select all teams that won either 1, 3, 5 or 7 games.
Is oracle better than mysql?
How do I kill a mysql query?
What is a simple query?
What is RMS Migrations
