mysql 生成9位随机数

SELECT FLOOR(RAND() * 1000000000);

CREATE TABLE random_numbers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    number BIGINT UNIQUE
);

INSERT INTO random_numbers (number)
SELECT FLOOR(RAND() * 1000000000)
FROM (
    SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4
    UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8
    UNION ALL SELECT 9 UNION ALL SELECT 10
) AS temp;

DELIMITER $$
CREATE PROCEDURE GenerateRandomNumbers(IN count INT)
BEGIN
    DECLARE i INT DEFAULT 0;
    WHILE i < count DO
        INSERT INTO random_numbers (number)
        SELECT FLOOR(RAND() * 1000000000)
        FROM (
            SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4
            UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8
            UNION ALL SELECT 9 UNION ALL SELECT 10
        ) AS temp;
        SET i = i + 1;
    END WHILE;
END$$
DELIMITER ;

CALL GenerateRandomNumbers(1000);