ID issue.

Hello,

Some time I ago my highest ID of a table was 803. I wanted to test something and made another row with the ID 8004 instead of 804. I deleted the row when I was done. But the issue is that everytime a user signs up on my page it gets the ID 8005, 8006, 8007, etc. Instead of 805, 806, etc. So it skips LOTS of ID's.

Is there a way to fix this?

Thanks

 

try to alter table to reset auto increment

ALTER TABLE table AUTO_INCREMENT=805

Code (markup):

but you should delete the id that greater than 804 to avoid conflict

 

Worked like a charm. Thanks alot!

 

you're welcome...