MySQL Forums
Forum List  »  Newbie

Primary Key with multiple fields
Posted by: Leon Mukkadan
Date: August 27, 2008 08:18AM

I have three columns:

Key Date & Time
First Touch Date & Time

Unfortunately several items might have the same Key Date & Time but no item would have the same Key Date & Time AND First Touch Date and Time. In essence I would like the combination of both these fields (without merging the column) to be my primary key.

Is this possible? How could I go about it?

I think what I would be looking for is a composite key but I don't understand how I would go about defining it. Thank you.

Options: ReplyQuote

Written By
Primary Key with multiple fields
August 27, 2008 08:18AM

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.