title: How to discard result set from statement like REPAIR TABLE in stored procedure of MySQL
body: <p>Is it possible to discard the result set of stored procedure which are not results from SELECT statement?</p>
  
  <p>If it is impossible from MySQL, is it possible from JDBC?</p>
  
  <p>The reason is that in our stored procedure, <code>REPAIR TABLE</code> is called in case of exception (in stored procedure) as table may crash. However there is a side effect of calling <code>REPAIR TABLE</code>, it returns over 200MB of result set ("The REPAIR TABLE statement might produce many rows of information for each repaired table." as stated in <a href="http://dev.mysql.com/doc/refman/5.6/en/repair-table.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.6/en/repair-table.html</a>).</p>
  
  <p>I know the result set was returned from <code>REPAIR TABLE</code> as I analyzed the heap dump from Java OutOfMemoryError happened in production.</p>