mySQL INT data type problem

[Anon]

Dear all,
i have created a table which has an auto_increment field (product_id). i have deleted some records from this field and then re-enterd the records. now the auto increment numbers are not in sequence i.e. the number starts from 10001 , 10002 and so on . After the nomber 10006, i have added more records but the number does not show it's very next number (10007). Instead it jumps to number 10009. Pls guide me what i should do bring auto_increment INT values in sequence.
Thanks.

[herve]

I haven't test that myself, but it seems
there's more than one solution to this
problem :

1)

ALTER TABLE tbl_name AUTO_INCREMENT = 1

will reset the counter to the current maximum
value

2)
SET INSERT_ID = (number)

set the value to be used by the next INSERT
(but you need to know the number of course)

[[deleted]]

Leave them as they are.

auto_increment numbers are record identifiers, they do not have to be in sequence.