Updates existing rows in an input window.
UPDATE window SET { column=value [,...] } [ WHERE whereclause ]
window |
An input window. |
whereclause |
An expression resulting in 1 for true, or 0 for false. |
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. Any columns that are not specified in the UPDATE statement are automatically set to NULL.
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'