mysql存储过程构建100000条虚拟数据

create table student(
id int primary key  auto_increment,
age int ,
name varchar(100),
index (age,name)
)


insert into student (age,name) values
(18,'fanjia'+'aa')




DELIMITER $$
DROP PROCEDURE IF EXISTS `insert_data`$$
CREATE PROCEDURE `insert_data`(IN student varchar(500),IN num INT)
BEGIN
  DECLARE n INT DEFAULT 1;/*定义一个变量，存储当前执行的次数*/
    WHILE n <= num DO
        SET @sqlStr = CONCAT("INSERT INTO student(age,name) VALUES(",n,",concat('fanjia',",n,"))");
        PREPARE stmt FROM @sqlStr;
        EXECUTE stmt;
        set n=n+1;
  end while;
END $$

call insert_data('student',1000000);