mysql写入随机数字

-- 创建一个测试表
CREATE TABLE random_numbers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    number INT
);

-- 插入100条随机整数数据
INSERT INTO random_numbers (number)
SELECT FLOOR(RAND() * 100) AS random_number
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;

-- 批量插入随机整数数据
INSERT INTO random_numbers (number)
SELECT FLOOR(RAND() * 100) AS random_number
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, (
    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 temp2;

-- 插入不重复的随机整数数据
INSERT INTO random_numbers (number)
SELECT DISTINCT FLOOR(RAND() * 100) AS random_number
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
WHERE number NOT IN (SELECT number FROM random_numbers);