How to suppress mysql stored procedure output?

You can set the required params into variables like

SET @foo = (SELECT foo_coloumn FROM foo_table);

This will suppress the select result set.