User-Defined Variables

SingleStore allows users to define variables to store values and reference these variables in subsequent queries.

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

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

SET @user_defined_variable = <expr>