[mysql.scalar]

mysql.scalar is a slot in the mysql namespace, in Hyperlambda, the language of Magic Cloud. Executes SQL and returns a scalar value from the current MySQL connection.

• Value (sql-scalar), required: SQL statement to execute
• Returns: Resolves to the scalar result of the SQL statement
• Scope: requires mysql.connection - Requires an open MySQL connection created by [mysql.connect]

Arguments

Required arguments come first, then the optional ones in the order they are declared.

Argument	Type	Required	Description
any node name	object	no	SQL parameter value; child name is used as the parameter name referenced by the SQL statement. Can be repeated.

JSON declaration

This is the complete declaration of mysql.scalar, as the running system describes it. It is also published as slot.json.

JSON declaration

{
  "name": "mysql.scalar",
  "description": "Executes SQL and returns a scalar value from the current MySQL connection",
  "signature": {
    "input": {
      "kind": "sql-scalar",
      "description": "SQL statement to execute",
      "required": true,
      "mode": "ValueOrExpression"
    },
    "children": {
      "*": {
        "type": "object",
        "kind": "sql-parameter-value,text,number,boolean,date,guid,content,value",
        "description": "SQL parameter value; child name is used as the parameter name referenced by the SQL statement",
        "required": false,
        "mode": "ValueOrExpression",
        "cardinality": "ZeroOrMore",
        "role": "Arguments",
        "projection": "Value"
      }
    },
    "scope": {
      "requires": "mysql.connection",
      "description": "Requires an open MySQL connection created by [mysql.connect]"
    },
    "output": {
      "mode": "Value",
      "description": "Resolves to the scalar result of the SQL statement"
    }
  }
}

---

← mysql.read

all mysql.* slots

mysql.select →