I just want to assign a variable from a query that returns a single value
result.
The problem is that the following will also emit (print) the result to the
terminal as a side effect.

SELECT @SomeVar := SomeFieldCalculation
FROM ...
WHERE ...

Is there not a simple way to accomplish this silently. IOW - get SELECT to
shut up since it is merely assigning a variable for use further along. Or
is there some other assignment syntax I should use that doesn't involve the
verbose SELECT.

And yes - I do know I can redirect the output to oblivion.

I just think I must be missing something ;-)
Thomas Bartkus

It's a bit of a hack, but you can do this:

set @somevar := ( select randomtext from random_table where ... );

Thomas Bartkus wrote:
> I just want to assign a variable from a query that returns a single value
> result.
> The problem is that the following will also emit (print) the result to the
> terminal as a side effect.
>
> SELECT @SomeVar := SomeFieldCalculation
> FROM ...
> WHERE ...
>
> Is there not a simple way to accomplish this silently. IOW - get SELECT to
> shut up since it is merely assigning a variable for use further along. Or
> is there some other assignment syntax I should use that doesn't involve the
> verbose SELECT.
>
> And yes - I do know I can redirect the output to oblivion.
>
> I just think I must be missing something ;-)
> Thomas Bartkus