Hi I solved it my self.
If anyone whats to know the awnser to this it was NOT as easy as the manual
would have described.
The only thing I got to work was:
1. Drop the index
2. create new field (whitout index and auto_inc) if any of them where added
I got an error and nothing worked.
3. make the new one an index (got an error but after flushing the table it
had made it an index anyway)
4. add the auto_inc.
And if someone can figure that procedure out with the manual.....
/roger
> check the manual under ALTER TABLE
>
> roger westin wrote:
>
> > Hi there,
> > Question:
> > Whats the Easiest way to insert an AUTO_INCREMENT column into an
existing table,
> > the new field will take over the primary key and the index.
>
>
---------------------------------------------------------------------
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
