Thanks for the speedy reply. I will try it out on some test tables.
Liz
On Mon, 17 Mar 2003, Paul DuBois wrote:
> At 18:08 -0600 3/17/03, Liz Buckley-Geer wrote:
> >I have an table with a column
> >
> >number INT NOT NULL PRIMARY KEY
> >
> >This table contains many records and there are gaps in the number
> >sequence. I would like to modify this column to use the AUTO
> >INCREMENT feature but I need to preserve the present numbering
> >sequence (which is monotonically increasing) including the holes. It
> >is not clear from the manual or my MySQL book exactly how to do this.
> >
> >Is this possible? if so what is the correct ALTER TABLE command?
>
> Interesting question.
>
> My tests suggest that, yes, you can do this. But make sure you backup
> the table first.
>
> The statement I used was
>
> ALTER TABLE tbl_name MODIFY number INT NOT NULL AUTO_INCREMENT;
>
> >
> > Thanks Liz
>
>
>
--
---------------------------------------------------------------------
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
