Finding the next SQL Auto increase? Opcje

[black77]

Hey there,

I am working on an achievement system for my website and I need to add an INSERT INTO function for the achievement table to the registration system.

My achievement system works based on user ID that matches the users table. I was wondering if it's possible to get the new unique ID column from the users table and insert it into the new row achivementOwnerID column.

Hopefully, I made this clear.

Thanks for your time and help!