Results from a MySQL Stored Procedure

I would like to found out more about returning data from MySQL Stored Procedures.
So if I put a couple of Select statements in the SP it comes back as multiple result sets - but it seems it assumes it’s all string, i.e.

  1. How can i format the returned data. ?StoredProcResultSchema {
    field_name (string, optional): The name of the returned element where the value is set to the requested type for the returned value, i.e. integer, boolean, string, etc.
    }
  2. Is there a way to name/categorise the result sets or is is the sequence in which it’s called in the SP that dictates this?