Skip to main content

LET statement

3 A parameter can store any value, including the result of a query.

Statement syntax

SurrealQL Syntax
LET $@parameter = @value;

Example usage

The following query shows example usage of this statement.

-- Define the parameter
LET $name = "tobie";
-- Use the parameter
CREATE person SET name = $name;

The following query shows the LET statement being used to store the result of a subquery.

-- Define the parameter
LET $adults = (SELECT * FROM person WHERE age > 18);
-- Use the parameter
UPDATE $adults SET adult = true;