RE: primary key based on unique value for two columns

2001-11-12 Thread Jonathan Hilgeman
corrected. - Jonathan -Original Message- From: Bill Adams [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 11:05 AM To: Brendin Cc: [EMAIL PROTECTED] Subject: Re: primary key based on unique value for two columns Brendin wrote: > I would like to have a table that has a primar

Re: primary key based on unique value for two columns

2001-11-12 Thread primej
ember 12, 2001 7:37 PM Subject: primary key based on unique value for two columns > I would like to have a table that has a primary key defined on a > combination of two columns in the table. In other words a unique key > based upon the values in two columns. > > I don't think I

RE: primary key based on unique value for two columns

2001-11-12 Thread Brendin
L PROTECTED] Subject: primary key based on unique value for two columns I would like to have a table that has a primary key defined on a combination of two columns in the table. In other words a unique key based upon the values in two columns. I don't think I am able to do this in mysql. I

RE: primary key based on unique value for two columns

2001-11-12 Thread Brendin
2:05 PM To: Brendin Cc: [EMAIL PROTECTED] Subject: Re: primary key based on unique value for two columns Brendin wrote: > I would like to have a table that has a primary key defined on a > combination of two columns in the table. In other words a unique key > based upon the values in two c

RE: primary key based on unique value for two columns

2001-11-12 Thread Jonathan Hilgeman
bject: primary key based on unique value for two columns I would like to have a table that has a primary key defined on a combination of two columns in the table. In other words a unique key based upon the values in two columns. I don't think I am able to do this in mysql. I think you can o

RE: primary key based on unique value for two columns

2001-11-12 Thread Carsten H. Pedersen
> I would like to have a table that has a primary key defined on a > combination of two columns in the table. In other words a unique key > based upon the values in two columns. > > I don't think I am able to do this in mysql. I think you can only have > a primary key on one column and not on a

RE: primary key based on unique value for two columns

2001-11-12 Thread Daniel Las
ry key based on unique value for two columns > > > I would like to have a table that has a primary key defined on a > combination of two columns in the table. In other words a unique key > based upon the values in two columns. > > I don't think I am able to do this in mysql.

Re: primary key based on unique value for two columns

2001-11-12 Thread Bill Adams
Brendin wrote: > I would like to have a table that has a primary key defined on a > combination of two columns in the table. In other words a unique key > based upon the values in two columns. > > I don't think I am able to do this in mysql. I think you can only have > a primary key on one colu

RE: primary key based on unique value for two columns

2001-11-12 Thread Rick Emery
Yes, you can have multi-column keys. see the manual, para. 6.5.3 CREATE TABLE Syntax -Original Message- From: Brendin [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 12:37 PM To: [EMAIL PROTECTED] Subject: primary key based on unique value for two columns I would like to

primary key based on unique value for two columns

2001-11-12 Thread Brendin
I would like to have a table that has a primary key defined on a combination of two columns in the table. In other words a unique key based upon the values in two columns. I don't think I am able to do this in mysql. I think you can only have a primary key on one column and not on a combination