MySQL Table alteration question

2002-08-21 Thread Paul Maine
The following table uses order_id as the primary key. My problem is that I need to be able to change order_id so that it is not a primary key. Next, I want to add a new auto incrementing key. What sql commands should I use to first back up the table and then to accomplish this modification. This

Re: MySQL Table alteration question

2002-08-21 Thread Neil Mansilla
On Wed, 21 Aug 2002, Paul Maine wrote: The following table uses order_id as the primary key. My problem is that I need to be able to change order_id so that it is not a primary key. Next, I want to add a new auto incrementing key. What sql commands should I use to first back up the table and