mysql while嵌套_Mysql在存储过程中嵌套while循环

目前我正在处理一个存储过程,其中我在另一个while循环下使用一个while循环.但我没有得到预期的结果.最外层的循环只是迭代一次.

我正在尝试下面的代码.

DELIMITER $$

DROP PROCEDURE IF EXISTS `First_Sp` $$

CREATE DEFINER=`root`@`localhost` PROCEDURE `First_Sp`()

BEGIN

DECLARE first_while_start INTEGER DEFAULT 1;

DECLARE second_while_start INTEGER DEFAULT 1;

DECLARE first_while_count INTEGER DEFAULT 3;

DECLARE second_while_count INTEGER DEFAULT 3;

WHILE first_while_start < first_while_count

DO

WHILE second_while_start < second_while_count

DO

SELECT concat(first_while_start,' - ',second_while_start) as result;

SET second_while_start = second_while_start + 1;

END WHILE;

SET first_while_start = first_while_start + 1;

END WHILE;

END $$

DELIMITER ;

结果：

mysql>