cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

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. 

 

Labels: (1)
0 Kudos
Reply