Naming resultsets

Xenos's profile image Xenos posted 6 years ago in General Permalink

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"?

Please login to leave a reply, or register at first.