mysql 随机生成数据

-- 创建一个示例表
CREATE TABLE random_data (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    age INT,
    email VARCHAR(100)
);

-- 插入随机数据
INSERT INTO random_data (name, age, email)
SELECT 
    CONCAT('User', RAND() * 1000),
    FLOOR(RAND() * 50) + 18,
    CONCAT('user', RAND() * 1000, '@example.com')
FROM 
    (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5) AS temp;

-- 使用外部字典文件生成随机名字
INSERT INTO random_data (name, age, email)
SELECT 
    SUBSTRING_INDEX(SUBSTRING_INDEX(file_content, '\n', FLOOR(RAND() * file_count) + 1), '\n', -1) AS name,
    FLOOR(RAND() * 50) + 18,
    CONCAT('user', RAND() * 1000, '@example.com')
FROM (
    SELECT COUNT(*) AS file_count, GROUP_CONCAT(name SEPARATOR '\n') AS file_content
    FROM (
        SELECT 'Alice' AS name UNION ALL SELECT 'Bob' UNION ALL SELECT 'Charlie' UNION ALL SELECT 'David'
    ) AS names
) AS temp;

-- 生成符合年龄范围的随机数据
INSERT INTO random_data (name, age, email)
SELECT 
    CONCAT('User', RAND() * 1000),
    FLOOR(RAND() * (60 - 20 + 1)) + 20,
    CONCAT('user', RAND() * 1000, '@example.com')
FROM 
    (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5) AS temp;