shadkeene@hotmail.com wrote:
>
> Hello sir, I know some sql syntax, so I've started from the beginning
> already with mysql/database design. Of course, I'm by no means even
> at an average level of database knowledge. But I've read several
> articles on using composite primary keys...mysql allows me to do
> that. The data I'm tracking seems like it needs composite primary
> keys in order to provide uniqueness to each row of data. Also, most
> of the tables/database examples that I've looked at seem to be using
> more ID numbers than dated/timed data. So, I guess what I'm getting
> at is trying to get advice on how I might arrange the other part of
> the composite key (times) so I can relate the tables together. If
> I'm way off, so be it.
> Shad

Tables can certainly have composite primary keys. But they can not have two
primary keys ,which is what you were suggesting.