Skip navigation links

MySQL Forums :: Newbie :: Primary Key with multiple fields


Advanced Search

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


Subject Written By Posted
Primary Key with multiple fields Leon Mukkadan 08/27/2008 08:18AM
Re: Primary Key with multiple fields laptop alias 08/27/2008 10:54AM


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.