mysql 随机生成记录

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

-- 插入随机记录
DELIMITER $$
CREATE PROCEDURE insert_random_data(IN num INT)
BEGIN
    DECLARE i INT DEFAULT 0;
    WHILE i < num DO
        INSERT INTO test_table (name, age, email)
        VALUES (
            CONCAT('User', FLOOR(RAND() * 1000)),
            FLOOR(RAND() * 50) + 18,
            CONCAT('user', FLOOR(RAND() * 1000), '@example.com')
        );
        SET i = i + 1;
    END WHILE;
END$$
DELIMITER ;

-- 调用存储过程插入100条随机记录
CALL insert_random_data(100);