Interested to Buy Any Domain ? << Click Here >> for more details...
how we can use more then one primary key in Single Table
- 9 Answers
- 16035 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
How to run a sql statement?
How to enable or disable a row of a table using MySQL in struts?
Will mysql remain free?
Why do we use pragma autonomous transaction?
How can you retrieve a particular number of records from a table?
What is the use of mysql_close()?
What is difference between pdo and mysqli?
What is mysql gpl?
How do I quit mysql?
What are Heap tables?
How to enter binary numbers in sql statements?
How to use 'mysql' to run sql statements?
Why use mysql procedures?
How to use sum function in where clause in mysql?
How is mysql database stored?
