From: Peter Brawley
Date: October 26 2006 4:50pm
Subject: Re: Can Primary Key be added with ALTER?
List-Archive: http://lists.mysql.com/mysql/202954
Message-Id: <4540E76D.4070908@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

>  I have a table with no primary key. I'd like to 
>make one of the table columns as the primary key. 
>Is it possible do it with ALTER? Is there any other way?

ALTER TABLE tblname ADD PRIMARY KEY (colname);

PB


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.408 / Virus Database: 268.13.13/500 - Release Date: 10/26/2006