# Reseting auto\_increment Numbers

**URL:** https://forum.kirupa.com/t/reseting-auto-increment-numbers/291096
**Category:** programming
**Created:** [June 24, 2009, 4:30pm UTC](https://forum.kirupa.com/t/reseting-auto-increment-numbers/291096 "2009-06-24T16:30:45Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![drummer392](https://avatars.discourse-cdn.com/v4/letter/d/45deac/32.png) [@drummer392](https://forum.kirupa.com/u/drummer392)
#### Post date: [June 24, 2009, 4:30pm UTC](https://forum.kirupa.com/t/reseting-auto-increment-numbers/291096/1 "2009-06-24T16:30:45Z")

</div>

Hey

I have a field called “id” with ‘auto\_increment’ on. So, when I add something new to the table, it automatically sets a number in numerical order. When I delete an item and then add another item, the field doesn’t give the new input the lowest possible number available, it just keeps counting up higher and higher. Is there a way to make it not keep counting higher and higher and just give the ‘id’ of the input the lowest available number?

Thanks,  
Brandon