Hi all,
  I have a small issue here. i have a table with column as 'id' hav an auto_increment feature. the table has 10 rows. when i delete the 9th row, " delete from myTable where id='9'; . then the 9th row gets deleted. Then the table would be like:

1
2
3
4
5
6
7
8
10.
Here the 10th row id is not changing to 9. How can that be done. some one please help.

Thanks in advance,
Prad.

http://bugs.mysql.com/bug.php?id=4165

http://dev.mysql.com/doc/refman/5.0/...nt-column.html

Stankovic Vlada

Prad,
In practice, I don't delete records with auto_increment field.
I usually take note of the ai (auto_increment) value in that field and update
it for a new one or last record. My reasoning is because in a multiuser environment
number of records in a table is usually related to another table.
in your example what I do is update row 10 to 9.
if this won't work make a copy and rename your table, copy the structure only the insert the values excluding the ai field from the copied table.
hope this helps.
jm

Hi John
  Thank you verymuch for ur reply. it gave me an idea.

Prad.