Dave Crawford wrote:
>
> I have a small table as follows:
> +--------+--------------+------+-----+---------+----------------+
> | Field | Type | Null | Key | Default | Extra |
> +--------+--------------+------+-----+---------+----------------+
> | ID | int(11) | | PRI | 0 | auto_increment |
> | name | varchar(25) | YES | | NULL | |
> | state | char(2) | YES | | NULL | |
> +--------+--------------+------+-----+---------+----------------+
>
> I had 50 some records inserted and was testing some delete commands:
>
> delete from table where (ID > 40);
>
> When I did a 'select * from table' I noticed that the remaining
> records had their ID's renumbered starting from 1. Is this a bug?
> The manual state's "If you delete the row containing the maximum
> value for an AUTO_INCREMENT column, the value will be reused. If
> you delete all rows in the table, the sequence starts over." But
> I didn't delete all the rows, so why did it renumber them? Normally
> it wouldn't be a big deal but I'm assigning a 'User #' that correlates
> to
> the ID number, so I need the ID column to always remain relative to the
> original record. Thanks in advance.
No, a documented ( in the manual) feature.
--
Sasha Pachev
http://www.sashanet.com
