Set the variable result, from query
There are multiple ways to do this. You can use a sub query: SET @some_var = (SELECT COUNT(*) FROM mytable); (like your original, just add parenthesis around the query) or use the SELECT INTO syntax to assign multiple values: SELECT COUNT(*), MAX(col) INTO @some_var, @some_other_var FROM tab; The sub query syntax is slightly faster (I … Read more