MySQL command line: Don't display results of query in a stored procedure
<p>I've got a procedure that uses a loop with a SELECT statement, but the statement is actually just to set a variable.  That means there's a lot of stuff being displayed that I don't need to see, and it's flooding my terminal.</p>

<p>Here's an example of what I mean, though this isn't actually what I'm running (because that's company information):</p>

<pre><code>DROP PROCEDURE IF EXISTS test;

DELIMITER #
    CREATE PROCEDURE test()
    BEGIN
        SET @key:=1;
        testloop: REPEAT
            SELECT
                @dummyString := stringField
            FROM
                aTable;

            SET @dummyStringAll :=CONCAT(@dummyStringAll,$dummyString);
            SET @key := @key + 1;

            UNTIL @key&gt;10
        END REPEAT testloop;
    END #
DELIMITER ;
</code></pre>

<p>Is it possible to run SELECT (whether inside a procedure or not) and <em>not</em> show the results from a SELECT query?  Maybe not the most important thing in the world, but it would be helpful.</p>