# Moving IDs in SQL

**URL:** <https://forum.kirupa.com/t/moving-ids-in-sql/247928>\
**Category:** programming\
**Created:** [January 1, 2008, 9:34pm UTC](https://forum.kirupa.com/t/moving-ids-in-sql/247928 "2008-01-01T21:34:05Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![whoist0m](https://avatars.discourse-cdn.com/v4/letter/w/e9bcb4/32.png) [@whoist0m](https://forum.kirupa.com/u/whoist0m)\
**Post date:** [January 1, 2008, 9:34pm UTC](https://forum.kirupa.com/t/moving-ids-in-sql/247928/1 "2008-01-01T21:34:05Z")

</div>

After searching google and forums I cant find this solution.

I want to insert an Id where one exists but instead of swapping its going to have to ++ to the rest of the ids in front of it? I’m assuming this will be done with a loop? Or because its auto increment it will automatically know to move everything up?