如何在mysql中生成一个范围内的多个唯一随机数

SELECT DISTINCT FLOOR((RAND() * (max_value - min_value + 1)) + min_value) AS random_number
FROM your_table
WHERE random_number NOT IN (SELECT generated_number FROM generated_numbers)
LIMIT number_of_random_numbers;

DELIMITER //

CREATE PROCEDURE generate_unique_random_numbers(min_value INT, max_value INT, number_of_random_numbers INT)
BEGIN
    DECLARE i INT DEFAULT 0;
    DECLARE random_number INT;
    
    CREATE TEMPORARY TABLE IF NOT EXISTS generated_numbers (generated_number INT);
    
    WHILE i < number_of_random_numbers DO
        SET random_number = FLOOR((RAND() * (max_value - min_value + 1)) + min_value);
        
        IF NOT EXISTS (SELECT 1 FROM generated_numbers WHERE generated_number = random_number) THEN
            INSERT INTO generated_numbers (generated_number) VALUES (random_number);
            SET i = i + 1;
        END IF;
    END WHILE;
    
    SELECT generated_number FROM generated_numbers;
    
    DROP TABLE IF EXISTS generated_numbers;
END //

DELIMITER ;

CALL generate_unique_random_numbers(1, 100, 10);