I have a MySQL database, and I call the following code:
DELIMITER $$
CREATE PROCEDURE showcase()
LANGUAGE SQL
BEGIN
SELECT 1;
SELECT 2;
END$$
DELIMITER ;
CALL showcase();
DROP PROCEDURE showcase;
HeidiSQL then yelds two resultsets "Result #1" and "Result #2", each with one column (respectively named "1" and "2") and one row (with value "1" and "2"):
Is there a way to change the resultset name, and tell (for instance) that "Resultset #1" should be named "users" and the seconde result set "Result #2" should be named "login_history"?