mysql 生成多条随机数

-- 生成 10 条 1 到 100 之间的随机整数
SELECT FLOOR(RAND() * 100) + 1 AS random_number
FROM (
    SELECT 1 AS n
    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 numbers;

SET @rand_seed = RAND();
SELECT FLOOR(@rand_seed * 100) + 1 AS random_number;

-- 生成 1 到 100 之间的随机整数
SELECT FLOOR(RAND() * 99) + 1 AS random_number;

-- 生成 20 条随机整数
SELECT FLOOR(RAND() * 100) + 1 AS random_number
FROM (
    SELECT 1 AS n
    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
    UNION ALL SELECT 11
    UNION ALL SELECT 12
    UNION ALL SELECT 13
    UNION ALL SELECT 14
    UNION ALL SELECT 15
    UNION ALL SELECT 16
    UNION ALL SELECT 17
    UNION ALL SELECT 18
    UNION ALL SELECT 19
    UNION ALL SELECT 20
) AS numbers;