Obtaining the key after a MySQL insert


I am trying to obtain the key value of an field after a MySQL insert command in Nintex Cloud



 



For example, I might run a mysql command INSERT INTO mytable (firstname,lastname) VALUES('John','Doe') and mytable contains the columns ID, firstname, lastname. Where ID is an autoincremented, key field.   



 



How can I reliably retrieve the value of ID for this insert command?



 



I cannot run a separate SELECT last_insert_id() command because Nintex connects different instances of the workflow with the same connection. I have tried this and it resulted in duplicate keys. 



 


0 replies

Be the first to reply!

Reply