<div>
If you use LAST_INSERT_ID() directly after the last query, then it will give you the right figure, since it calculates on a per-connection basis. See:<br />
<br />
<a href="http://www.mysql.com/doc/en/Getting_unique_ID.html" rel="ugc">http://www.mysql.com/doc/en/Getting_unique_ID.html</a><br />
<br />
If you want to get the most recently inserted row after you have closed a connection and re-opened it, I can only think you need to have a date_created(TIMESTAMP) column on your table and SELECT MAX(date_created) from it to get this result.
</div>


If you use LAST_INSERT_ID() directly after the last query, then it will give you the right figure, since it calculates on a per-connection basis. See:

http://www.mysql.com/doc/en/Getting_unique_ID.html [http://www.mysql.com/doc/en/Getting_unique_ID.html]

If you want to get the most recently inserted row after you have closed a connection and re-opened it, I can only think you need to have a date_created(TIMESTAMP) column on your table and SELECT MAX(date_created) from it to get this result.

<div>
leannonn, you came through for me again. that's exactly what i needed.
</div>


leannonn, you came through for me again. that's exactly what i needed.

<div>
leannonn: I need you over here:<br />
<a href="https://www.experts-exchange.com/questions/20890859/date-comparisons.html#10404157" rel="ugc">https://www.experts-exchange.com/questions/20890859/date-comparisons.html#10404157</a><br />
<br />
sorry, but this site offers no other way to contact somebody!!!<br />
<br />
thanks.
</div>


leannonn: I need you over here:
https://www.experts-exchange.com/questions/20890859/date-comparisons.html#10404157 [https://www.experts-exchange.com/questions/20890859/date-comparisons.html#10404157]

sorry, but this site offers no other way to contact somebody!!!

thanks.

<div>
<div class="content wysiwyg-content">
I need to know the last auto_increment value inserted into a given table. in my experiments with last_insert_id, it seems this gives the last id value anywhere in the database, which is useless. is there a way to get the last id value for a specific table?<br />
<br />
i can't use max(id) because there are times when the last record was deleted, and i don't want to get the highest id currently in the table, but the highest id that was *ever* in the table.
</div>
</div>


I need to know the last auto_increment value inserted into a given table. in my experiments with last_insert_id, it seems this gives the last id value anywhere in the database, which is useless. is there a way to get the last id value for a specific table?

i can't use max(id) because there are times when the last record was deleted, and i don't want to get the highest id currently in the table, but the highest id that was *ever* in the table.

last_insert_id

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.