This article is tagged with:
User defined variables in sql
and mysql
user defined variables in sql
SET @var_name = expr [, @var_name = expr] ...