You have been using mySQL for 15 years now and you don't know about this? hahahahha
Well the documentation says that when you append it to your insert statement you get THAT PKEY value even in multi insert conditions to the same table by others. Think of EBAY and last seconds of an auction with a few to a few hundred bids coming in.
If you are inserting and then doing a separate statement with the same spid you should get your insert pkey but if you have done multiple inserts which one are you getting?
You should experiment with some of these methods. http://www.mysqltutorial.org/mysql-stored-procedure-tutorial.aspx
I had to laugh at the causal warnings about getting too fancy in your sprocs. Glad the don't like at mine. hahahahaha.
On Thu, Mar 10, 2016 at 9:59 AM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 2016-03-10 10:51, Stephen Russell wrote:
You may get the incorrect value back buy doing this: So I'm thinking "how do I get something like VFP's old NextKey generation" akin to this:
- this was pseudo-code, off the top of my head trying to remember my
coding from 17+ years ago FUNCTION GetNextKey(tcTable as String) as Integer
<snip>
In the same insert statement you append ; select last_insert_id() ; and it returns YOUR value no matter what type of data column the key is. If you do some super fancy secondary select someone else may have gotten an insert in as well and your code returns their key, not yours.
Ah, I see it now. Sorry, I thought you were in SQL Server land with your answer. Yes, that's MySQL. So that should work, right? Or can this fail somehow if others are inserting simultaneously?
[excessive quoting removed by server]