title: How can you disable result output for the mysql EXECUTE command in workbench
body: <p>I'm trying to use a prepared statement in mysql workbench in a cursor. The cursor works on a very big data set so it is executed many times. Every time a new result is shown for the EXECUTE step. This results eventually in mysql workbench crashing because of too many open result windows. </p>
  
  <p>In the cursor I do something like this:</p>
  
  <pre><code>PREPARE stmt2 FROM @eveningQuery;
  EXECUTE stmt2; 
  DEALLOCATE PREPARE stmt2;
  </code></pre>
  
  <p>Normally I use stuff like </p>
  
  <pre><code>set aVar = (EXECUTE stmt2); 
  </code></pre>
  
  <p>to silence the query but EXECUTE doesn't work like that. </p>
  
  <p>Does anybody know how you can disable the output for the EXECUTE command in mysql?</p>
  
  <p>Note: I understand how i can retrieve the data in a variable, however what I want to prevent is that it is displayed in the results overview like this <img src="https://i.stack.imgur.com/9cJpj.png" alt="enter image description here"> </p>
  
  <p>This will make mysql-workbench crash when looped too much. </p>
  
  <p><em>edit</em> because it was asked an example of the @eveningQuery. </p>
  
  <blockquote>
    <p>SET @eveningQuery = CONCAT('select @resultNm := exists (select  idSplitBill  from tb_SplitDay where idSplitBill =', idSplitBillVar, ' and ', @columnNameEv ,' = 1 and softdelete = 0)'); </p>
  </blockquote>
  
  <p>idSplitBillVar = the id coming from the cursor. 
  @columnNameEv = a column that i am filling in variably. </p>
  
  <p>I added this info because it was asked, however it doesn't really matter in my opinion because the question still stands even with the most simple query. When you execute a prepared statement, you will get a output result. I just want to disable this behaviour.</p>