How to suppress mysql stored procedure output?

Question

so if i have a stored procedure that contains selects how to suppress the results from these selects from appearing ?

for example if i have

create procedure xyz
begin    
    select * from table_name #I don't want this to be seen in the console.    
    do other stuff     
end;

Answer 1

You can set the required params into variables like

SET @foo = (SELECT foo_coloumn FROM foo_table);

This will suppress the select result set.