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 names are not
> null. MySQL is reporting a syntax error. What is the error please?
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
