how to store the result of sql query in a variable code example

Example: how to store the query result in a variable sql

SET @anyVariableName = ( yourQuery);