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
-- Paul DuBois http://www.kitebird.com/ sql, query
--------------------------------------------------------------------- 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