[Download] | [Documentation Home] | [Release Note]
Introduction
"Return Generated Keys" feature can be used when inserting data to a table that has auto increment key column. This will map the auto incremented key value of that record to result output mappings in data service.
Following sample insert query is used to insert values to table called 'wes_teams' which has auto increment column.
Figure 01: Insert Query
Once click on Return Generated Keys it will add the auto increment key as output mapping.
Figure 02: Click on Return Generated Keys