如何使用SQL语句为单表生成20万条数据

1.DDL建表语句student1

CREATE TABLE student1 (
    ID INT PRIMARY KEY AUTO_INCREMENT, -- 假设使用自增ID
    createtime DATETIME NOT NULL,
    userName VARCHAR(50) NOT NULL,
    phone VARCHAR(20) NOT NULL,
    age INT NOT NULL,
    sex VARCHAR(10) NOT NULL,
    introduce TEXT
);

2.DML语句和控制循环变量

DELIMITER //
CREATE PROCEDURE InsertStudentData(IN num_rows INT)
BEGIN
    DECLARE v_counter INT DEFAULT 0;
    DECLARE v_username VARCHAR(50);
    DECLARE v_phone VARCHAR(20);
    DECLARE v_age INT;
    DECLARE v_sex VARCHAR(10);
    DECLARE v_introduce TEXT;

    WHILE v_counter < num_rows DO
        -- 这里使用了一些简单的随机值生成方法，你可能需要替换为更复杂的逻辑
        SET v_username = CONCAT('User', FLOOR(RAND() * 1000000));
        SET v_phone = CONCAT('1', FLOOR(RAND() * 10000000000));
        SET v_age = FLOOR(RAND() * 100); -- 假设年龄范围在0-99之间
        SET v_sex = IF(RAND() > 0.5, '男', '女');
        SET v_introduce = CONCAT('Student introduce ', FLOOR(RAND() * 1000));

        INSERT INTO student1 (createtime, userName, phone, age, sex, introduce) VALUES
        (NOW(), v_username, v_phone, v_age, v_sex, v_introduce);

        SET v_counter = v_counter + 1;
    END WHILE;
END //
DELIMITER ;
CALL InsertStudentData(200000);