I have a table on mysql db, with an auto-increment ID field.
The scenario is as following:
- Save data to a mySQL table
- Retrieve the assigned ID field value (as mentioned it's auto increment, so the DB is assigning the value to the ID field)
- Use the ID value in a REST API call
- Update the above record with a returned value from the API
I'm having difficulties in getting the value assigned to the ID field, would appreciate your help in pointing me out to the right direction