Result Set Update Query. Either way thats a result set. In the Result Set tab you must specify the result name and the variable that you want to map to.
Specifies the temporary named result set or view also known as common table expression CTE defined within the scope of the UPDATE statement. The javasqlResultSet interface represents the result set of a database query. In SQL a result table is retrieved through a cursor that is named.
The current row of a result set can be updated or deleted using a positioned updatedelete statement that references the cursor name.
In this article I will provide a set of examples to showcase the use of OUTPUT clause in capturing the results of the updated rows into a table variable for the UPDATE statements. The Data Output tab displays the result set of the query in a table format. The following code block has a generic SQL syntax of the UPDATE command to modify the data in the MySQL table UPDATE table_name SET field1 new-value1 field2 new-value2 WHERE Clause You can update one or more field altogether. Use the Save results to file icon to save the content of the Data Output tab as a comma-delimited file.