[sql.update]
sql.update is a slot in the sql namespace, in Hyperlambda, the language of Magic Cloud. Builds a parameterized UPDATE SQL statement; use [where] to constrain affected rows.
- Returns: Resolves to the generated SQL string in value and the generated parameter nodes as children
Arguments
Required arguments come first, then the optional ones in the order they are declared.
| Argument | Type | Required | Description |
|---|---|---|---|
[table] |
string | yes | Table name to use in the SQL statement. |
[values] |
lambda | yes | Column values to insert or update. |
[values] / any node name |
object | yes | Column name and value. Can be repeated. |
[where] |
lambda | no | Optional boolean predicate tree. |
[where] / [and] |
lambda | no | Boolean AND group. |
[where] / [and] / any node name |
object | yes | Column condition; suffix the name with .eq, .neq, .gt, .gte, .lt, .lte, .like, .ilike, or .in to select an operator. Can be repeated. |
[where] / [and] / any node name / unnamed child node |
object | no | Value item used by operators such as .in. |
[where] / [and] / [or] |
lambda | no | Boolean OR group. Can be repeated. |
[where] / [and] / [or] / any node name |
object | yes | Column condition; suffix the name with .eq, .neq, .gt, .gte, .lt, .lte, .like, .ilike, or .in to select an operator. Can be repeated. |
[where] / [and] / [or] / any node name / unnamed child node |
object | no | Value item used by operators such as .in. |
[where] / [or] |
lambda | no | Boolean OR group. |
[where] / [or] / any node name |
object | yes | Column condition; suffix the name with .eq, .neq, .gt, .gte, .lt, .lte, .like, .ilike, or .in to select an operator. Can be repeated. |
[where] / [or] / any node name / unnamed child node |
object | no | Value item used by operators such as .in. |
[where] / [or] / [and] |
lambda | no | Boolean AND group. Can be repeated. |
[where] / [or] / [and] / any node name |
object | yes | Column condition; suffix the name with .eq, .neq, .gt, .gte, .lt, .lte, .like, .ilike, or .in to select an operator. Can be repeated. |
[where] / [or] / [and] / any node name / unnamed child node |
object | no | Value item used by operators such as .in. |
Nodes nested deeper than 6 levels, and nodes that repeat one of their own ancestors, are not listed. The JSON declaration below has all of them.
Guide
JSON declaration
This is the complete declaration of sql.update, as the running system describes it. It is also published as slot.json.
JSON declaration (loads when opened)
← sql.read |
all sql.* slots |