sql:update

Performs an SQL UPDATE statement. This causes a set of rows to be selected from a given table; columns identified in a child sql:column element are then updated with new values.

Attributes

connection

expression

The database connection. The value is an expression, which must evaluate to a database connection object as returned by sql:connect.

table

string

The table to be updated. The value must be known statically (it cannot be defined as an attribute value template).

where?

{ expression }

The conditions to be applied (the contents of the WHERE clause of the select statement). If present the value is an attribute value template whose value is a SQL conditional expression. If omitted, all rows in the table are updated.

Saxon availability

Requires Saxon-PE or Saxon-EE. Available for Java only.

Details

An sql:column may be used as a child element of sql:update, to identify the name and value of a column to be included in the UPDATE statement. The name of the column is identified by the name attribute, the value may be indicated either by evaluating the expression contained in the select attribute, or as the expanded contents of the sql:column element. The value is converted to the required data type (the declared type of the column) if possible.