MENU
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

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:

Child looking at teacher on computer screen
The past year has certainly been a somewhat challenging and stressful time for teachers and pupils alike with the effects of the covid-19 pandemic disrupting the academic year. Teachers have had to rethink how they are able to teach their students and come up with innovative ways to encourage pupil...
11 Hidden Android Settings You Should Know About
If you're new to Android, or perhaps you've had an Android device for a while and are looking for some ways to optimise it then this is the article for you! Here we look at 11 tweaks you can make to free up space, change up your voice assistant or...
Skillshare - From Proficient To Pro

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

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 FlippingHeck.com, 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 flippingheck.com may receive financial compensation which contributes to the running of the site. For more information please read our Advertising & Affiliate Disclosure Policy
Filed Under:

3 Comments

  •  

    “Could you not use MAX() to get the highest ID number?”

  •  

    “Could do, but if someone else was updating the recordset at the same time apparently it could get a bit screwey, there’s several ways of doing it.”

  •  
    Kreative Place
    July 9, 2015 at 5:33 pm

    I have been surfing for mire than three hours today, and
    i’m yet to find a page like yours. It has made my effort online worth while.
    In my view, if all site owners andd bloggers
    prodcuced good content like this, the webb would
    be a ore useful resource.

Leave a Reply to Kreative Place Cancel reply

Your email address will not be published. Required fields are marked *