Using a SELECT Statement in a LET Statement
The examples in this section use a SELECT statement in a LET statement.
You can use a SELECT statement to assign values to one or more variables
on the left side of the equals ( = ) operator, as the following example
shows:
LET a,b = (SELECT c1,c2 FROM t WHERE id = 1);
LET a,b,c = (SELECT c1,c2 FROM t WHERE id = 1), 15;
You cannot use a SELECT statement to make multiple values operate
on other values. The following example is invalid:
LET a,b = (SELECT c1,c2 FROM t) + (10,15); -- INVALID CODE
Because a LET statement is equivalent to a SELECT ... INTO statement,
the two statements in the following example have the same results:
a=c
and b=d
:
CREATE PROCEDURE proof()
DEFINE a, b, c, d INT;
LET a,b = (SELECT c1,c2 FROM t WHERE id = 1);
SELECT c1, c2 INTO c, d FROM t WHERE id = 1
END PROCEDURE
If the SELECT statement returns more than one row, you must enclose the SELECT statement in a FOREACH loop.
For a description of SELECT syntax and usage, see SELECT statement.