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