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
numberINT 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