MySQL Forums
Forum List  »  Optimizer & Parser

Composite Primary Key
Posted by: Gaurav Sharma
Date: April 27, 2010 05:30AM

Hi ALL,

Can anybody tell me the significance of Composite Primary key , i created a table with composite primary key with the following structure

"primary key(id,email,name)"

When i am trying to insert the row in the table it is allowing to insert null or empty or even duplicate values in the name and email filed.

So please help me to understand the concept of composite primary key.

Any help or suggestion would be greatly appreciated.

Thanks
Gaurav

Options: ReplyQuote


Subject
Views
Written By
Posted
Composite Primary Key
4583
April 27, 2010 05:30AM
1880
April 29, 2010 11:19PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.