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