User-Defined Variables

SingleStore allows users to define session variables to store values and reference these variables in subsequent queries. These user-defined variables are session variables meaning that they exist only during your session and are local in scope to your session.

You can use SELECT ... INTO or SET to create user defined session variables.

SELECT ... INTO @user_defined_variable [,...]

SET @user_defined_variable = <expr>

For stored procedures and anonymous code blocks, you can use SELECT ... INTO <var> to create variables; however, those variables are locally scoped variables, not session variables.