能够让用户去确定生成数据的数量。（比如随机生成100，1000或10000条数据）SQL语句

DELIMITER $$
CREATE PROCEDURE dowhile()
BEGIN
DECLARE i INT DEFAULT 0;
START TRANSACTION;
WHILE i<10 DO
insert into dede_member (userid,'',uname) value (concat(char(floor(rand()*26)+97), char(floor(rand()*26)+97), char(floor(rand()*26)+97), char(floor(rand()*26)+97),

char(floor(rand()*26)+97)),concat(char(floor(rand()*26)+97), char(floor(rand()*26)+97), char(floor(rand()*26)+97), char(floor(rand()*26)+97), char(floor(rand()*26)

+97)));
SET i=i+1;
END WHILE;
COMMIT;
END $$
DELIMITER ;

call dowhile();