Seeking silence!

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

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

SELECT @SomeVar := SomeFieldCalculation
FROM ...

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

Re: Seeking silence!

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

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

Thomas Bartkus wrote:
Quoted text here. Click to load it

Site Timeline