I set up a stored procedure test,
CREATE PROCEDURE test (OUT result INT)
The BEGIN... END;
Then use the stored procedure: the CALL test (@ result1);
Variable result1 save the result of the stored procedure,
Then I create a lot of stored procedures, through the CALL statement USES the stored procedure, and variable result1 to resultn to store the results of these stored procedures,
So how can I suddenly see all these variables and their values?

CodePudding user response:

To look at bai,
Select @ result1, @ result2, @ resultn;

Or generate such statements, to carry out,
PREPARE
The execute