# After deleting MySQL table records

**URL:** <https://forum.kirupa.com/t/after-deleting-mysql-table-records/193593>\
**Category:** Uncategorized\
**Created:** [July 14, 2006, 12:47pm UTC](https://forum.kirupa.com/t/after-deleting-mysql-table-records/193593 "2006-07-14T12:47:05Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![theHollow](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/thehollow/32/106_2.png) [@theHollow](https://forum.kirupa.com/u/theHollow)\
**Post date:** [July 14, 2006, 12:47pm UTC](https://forum.kirupa.com/t/after-deleting-mysql-table-records/193593/1 "2006-07-14T12:47:05Z")

</div>

I have a table with 3 columns (id, text, and status) the id is primary key and is set to auto increment. When I delete a record (say record 3) and I have 5 record total, I am left with a gap in the id column. Is there a way to stop this? So when 3 is deleted, 4 becomes 3 and 5 becomes 4.

Brendan.