Interested to Buy Any Domain ? << Click Here >> for more details...
how we can use more then one primary key in Single Table
- 9 Answers
- 15927 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 the default password for mysql?
How database are managed?
What is the usage of ENUMs in MySQL?
How do you rename a procedure in mysql?
What are the disadvantages of mysql?
What are date and time data types in mysql?
How do I edit a table in mysql workbench?
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
How many queries can mysql handle?
What are the steps required to view your mysql database?
How are mysql timestamps seen to a user?
What is localhost in mysql?
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
Why do we use the mysql database server?
What is mysql connection limit?
