插入的测试数据规则为:
empname - 四位随机字符串
age - [18,65 ]
salary - [1320,10000]
存储过程代码:
DELIMITER $$
DROP PROCEDURE IF EXISTS `test`.`f` $$
CREATE PROCEDURE `test`.`f` (loop_time int)
BEGIN
DECLARE i int default 0;
WHILE i < loop_time DO
insert into empinfo (empname,age,salary) values
(char(floor(97+(rand()*26)),floor(97+(rand()*26)),floor(97+(rand()*26)),floor(97+(rand()*26))),
floor(18+(rand()*48)),
floor(1320+(rand()*8680)));
SET i = i + 1;
END WHILE;
select * from empinfo;
END $$
DELIMITER ;
CALL f(1000000);
empname - 四位随机字符串
age - [18,65 ]
salary - [1320,10000]
存储过程代码:
DELIMITER $$
DROP PROCEDURE IF EXISTS `test`.`f` $$
CREATE PROCEDURE `test`.`f` (loop_time int)
BEGIN
DECLARE i int default 0;
WHILE i < loop_time DO
insert into empinfo (empname,age,salary) values
(char(floor(97+(rand()*26)),floor(97+(rand()*26)),floor(97+(rand()*26)),floor(97+(rand()*26))),
floor(18+(rand()*48)),
floor(1320+(rand()*8680)));
SET i = i + 1;
END WHILE;
select * from empinfo;
END $$
DELIMITER ;
CALL f(1000000);