User-Defined Variables

On this page

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.

In this section

Last modified: April 3, 2024

Was this article helpful?