存储过程双重循环插入SQL

-- 创建插入数据的存储过程
DROP PROCEDURE IF EXISTS `add_vote_record_memory`;
DELIMITER //
CREATE PROCEDURE `add_vote_record_memory`(IN n INT)
BEGIN
    DECLARE i INT DEFAULT 1;
    DECLARE j INT DEFAULT 1;
    DECLARE xx INT DEFAULT 100;
    WHILE i < n DO
				WHILE j<xx DO
					INSERT INTO `amend_policy` (order_no, amend_no)
					VALUES
					(i, j);
					set j = j + 1;
				END WHILE;
        SET i = i + 1;
				set xx = xx + j;
    END WHILE;
END //
DELIMITER ;  -- 改回默认的 MySQL delimiter：';'

CALL add_vote_record_memory(50);