# Jumping Auto Increment

**URL:** https://forum.kirupa.com/t/jumping-auto-increment/89350
**Category:** programming
**Created:** [May 7, 2005, 12:05pm UTC](https://forum.kirupa.com/t/jumping-auto-increment/89350 "2005-05-07T12:05:42Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![DaveMania](https://avatars.discourse-cdn.com/v4/letter/d/5daacb/32.png) [@DaveMania](https://forum.kirupa.com/u/DaveMania)
#### Post date: [May 7, 2005, 12:05pm UTC](https://forum.kirupa.com/t/jumping-auto-increment/89350/1 "2005-05-07T12:05:42Z")

</div>

I have a problem where my id column (set to auto increment) goes up by too much and doesn’t reset when there are no rows in the table.

Rows | 0  
Next auto index | 5 (or near enough)

Can anybody tell me how to fix this?