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.

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

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.