How we declare temporary variable in MySQL ..

Question

Declaration of temporary variable..

Answer 1

SET @anyVariableName=(SELECT yourColumnName FROM yourTableName WHERE yourCondition);

See this link
https://www.tutorialspoint.com/mysql-temporary-variable-assignment