Flipping Heck! Learning To Be Productive One Day At A Time

Find the Last inserted Auto increment ID in MYSQL with ASP

Find the Last inserted Auto increment ID in MYSQL with ASP

It’s taken me ages to find out how to do this (what turns out to be a) relatively simple operation.

Here’s the problem. Table 1 has a user_id which is auto incremented by MYSQL. Table 2 has an auto incremented login_id but also requires the user_id. Here’s how we get one ID from one table to the other:

objRS.source = “Select LAST_INSERT_ID() from Table1”
LastID = objRS(“LAST_INSERT_ID()”)

Simple! We can then refer to the LastID in Table 2

About The Author
Katy is always trying to be more productive one day at a time! Whether it's analogue, digital, motivational or psychological who'll try any system that will help her get things done and get organised. As well as running, she also loves making music and reviewing things.
  • Follow Katy Whitton on:
Please Note: This post may contain affiliate links. By clicking on these links you will not be charged any extra for purchasing goods and services from our preferred partners however may receive financial compensation which contributes to the running of the site. For more information please read our Advertising & Affiliate Disclosure Policy
Filed Under:
Like what you're reading? Buy Katy a coffee and help support this site


Leave a Reply

Your email address will not be published.