存储过程向MySql 数据库中批量插入测试数据
插入的测试数据规则为：empname - 四位随机字符串
age -
salary-
存储过程代码：
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 intoempinfo (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);
页:
[1]