[plug] auto-increment in mysql

[Jon Miller]

It all done and working now, just need to work on my php coding.  Seems
the index field in MySQL isn't translating when I do a listing of the
info in a web browser.
jlm

On Fri, 2003-01-03 at 15:37, sscott at iinet.net.au wrote:
> It appears I may have been redundant with my 'unique index' comments - oh 
> well :D
> 
> By the way, in response to the original query. I havent used MySQL, but 
> you *should* be able to 
> 
>    a) drop the primary key on the table
>    b) add the auto-increment field to the table (it doesnt really have to 
> be the first field, but it is neater)
>    c) create the primary key again using the auto increment field
> 
> Or, more than likely, create the new table in the structure you require, 
> copy the data over, then drop the original table and rename the new one to 
> the old one's name.
> 
-- 
Jon Miller <jlmiller at mmtnetworks.com.au>
MMT Networks Pty Ltd