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
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
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
.
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
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
: 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
: 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
: 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
: 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
.
- 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
10 matches
Mail list logo