Re: remove primary keys

2002-11-13 Thread Jeremy Zawodny
On Wed, Nov 13, 2002 at 05:03:38PM -0200, Silmara wrote: > I'm working with MySQL-Innodb and I have one table with primary key composed > by the 5 first fields, and I want to change this removing the primary keys > attributes and add one new field in the first position as primary key and > auto_inc

remove primary keys

2002-11-13 Thread Silmara
I'm working with MySQL-Innodb and I have one table with primary key composed by the 5 first fields, and I want to change this removing the primary keys attributes and add one new field in the first position as primary key and auto_increment. How can I do this? best regards, Sil -