UPDATE statement

Start of changeThe UPDATE statement changes the values of specified columns, in selected rows, in a table in an external database.End of change

SYNTAX

Handling errors

For further information about handling database errors, see Capturing database state.

Start of change

Examples

Start of changeThe following example assumes that the dataSource property of the Database node has been configured, and that the database it identifies has a table called STOCKPRICES, with columns called COMPANY and PRICES. It updates the PRICE column of the rows in the STOCKPRICES table whose COMPANY column matches the value given in the Company field in the message.
UPDATE Database.StockPrices AS SP
 SET PRICE = InputBody.Message.StockPrice
 WHERE SP.COMPANY = InputBody.Message.Company
End of change
End of change
Related concepts
ESQL overview
Related tasks
Developing ESQL
Capturing database state
Related reference
Syntax diagrams: available types
ESQL statements