Updates existing rows in an input window.
UPDATE window SET { column=value [,...] } [ WHERE whereclause ]
window |
An input window. |
whereclause |
Updates rows that match the whereclause condition. |
value |
An expression that evaluates to a value of the same data type as the specified column. |
column |
The name of a destination column to which value is published. |
The UPDATE statement updates existing rows in an INPUT window. It cannot be used with streams. The UPDATE statement updates the rows identified by the WHERE clause if one is provided or updates all the rows if one is not provided. The values of any columns that are not specified in the UPDATE statement are maintained.
Note that you cannot use esp_query to run concurrent UPDATE statements on the same window or stream.
UPDATE Trades SET Price = 0.0 WHERE Symbol <> 'SAP'