MySQL Forums
Forum List  »  Newbie

Re: Need Database Structure Help
Posted by: Chad Bourque
Date: October 19, 2010 08:03PM

Alex,

You can have compound primary keys:

create table foo
(
  col1 int not null,
  col2 varchar(5) not null,
  col3 int not null,
  col4 datetime null,
  constraint pk_foo
    primary key (col1, col2, col3)
);

HTH,
Chad
Milamade, LLC - Custom Software Development

Options: ReplyQuote


Subject
Written By
Posted
October 09, 2010 11:43AM
Re: Need Database Structure Help
October 19, 2010 08:03PM
October 20, 2010 09:16AM


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.