存储过程向MySql 数据库中批量插入测试数据

插入的测试数据规则为：
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);