User-Defined Variables

On this page

SingleStore allows users to define variables to store values and reference these variables in subsequent queries. These 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 variables.

SELECT ... INTO @user_defined_variable [,...]
SET @user_defined_variable = <expr>

In this section

Last modified: March 27, 2024

Was this article helpful?