创建测试表:

use  testdb;
CREATE TABLE `test01` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `titles` char(15) NOT NULL,
  `icon` smallint(6) unsigned DEFAULT '0',
  `integral` int(10) NOT NULL DEFAULT '0',
  `isdefault` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `create_time` timestamp NOT NULL COMMENT '创建的时间',
  `update_time` timestamp NOT NULL COMMENT '修改的时间',
  PRIMARY KEY (`id`),
  KEY `integral` (`integral`)
) ENGINE=Innodb AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4  COLLATE utf8mb4_unicode_ci ;

创建插入10万数据的存储过程:

DELIMITER //
CREATE PROCEDURE GenerateData()
BEGIN
  DECLARE i INT DEFAULT 1;
  WHILE i <= 100000 DO
    insert into testdb.test01(titles,icon,integral,isdefault,create_time,update_time) values('班长',1,0,1,now(),now());
    SET i = i + 1;
  END WHILE;
END //

DELIMITER ;
CALL GenerateData();