Hi,
Its in the manual, but it is something like
ALTER TABLE Discharge ADD PRIMARY KEY (Vessel, Voyage, PortName);
Regards
Quentin
-Original Message-
From: Don [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 23 January 2001 10:39
To: msql list
Subject: Creating keys
The online
Do this instead:
ALTER TABLE Discharge ADD PRIMARY KEY (Vessel, Voyage, PortName);
-Tilghman
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From: Don [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 22, 2001 15:39
>
The online documentation only has a syntax example of creating a key
consisting of a single column. I wish to create a primary key
encompassing three columns. Here is my syntax:
create primary key on Discharge (Vessel, Voyage, PortName);
where Discharge is my table name and all three fields na
