# Get an auto\_increment value

**URL:** <https://forum.kirupa.com/t/get-an-auto-increment-value/226021>\
**Category:** Uncategorized\
**Created:** [May 17, 2007, 3:12pm UTC](https://forum.kirupa.com/t/get-an-auto-increment-value/226021 "2007-05-17T15:12:12Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![forza\_stiinta](https://avatars.discourse-cdn.com/v4/letter/f/bc79bd/32.png) [@forza\_stiinta](https://forum.kirupa.com/u/forza_stiinta)\
**Post date:** [May 17, 2007, 3:12pm UTC](https://forum.kirupa.com/t/get-an-auto-increment-value/226021/1 "2007-05-17T15:12:12Z")

</div>

Hello!  
I have an id field in a mysql table, with is unique and auto\_increment.  
How can I get the value of the ID, right after i make an insertion? (i do not want to query using select and limiting the select to having the rest of the other fields the same as when doing the insertion)