how we can use more then one primary key in Single Table
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
How do I view data in mysql workbench?
Is mysqli secure?
How does mysql store binary data?
What is full form of xampp?
What is the difference between is null & is not null?
How to convert numeric values to character strings?
What is mysql procedure?
how to display nth highest salary from a table in a mysql query? : Mysql dba
How to get a version of mysql?
Write a command with which mysql table can be repaired
Write a query to display current date and time?
Is mysql free software?
How do you kill a long running query in mysql?
How do I install the latest mysql on ubuntu?
Is pdo faster than mysqli?