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

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

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 column

RE: primary key based on unique value for two columns

2001-11-12 Thread Daniel Las
. WWW: http://www.e-direct.pl E-mail: [EMAIL PROTECTED] 45-072 Opole ul. Reymonta 45 tel. +48 77 44 26 073 fax. +48 77 44 26 074 -Original Message- From: Brendin [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 7:37 PM To: [EMAIL PROTECTED] Subject: primary key based on unique

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 Jonathan Hilgeman
: 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 only have

RE: primary key based on unique value for two columns

2001-11-12 Thread Brendin
: 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 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
: 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 only have

Re: primary key based on unique value for two columns

2001-11-12 Thread primej
: 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 only

RE: primary key based on unique value for two columns

2001-11-12 Thread Jonathan Hilgeman
. - 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 primary key defined