78LeWEky

1-- select FLOOR(RAND() * (<max> - <min> + 1)) + <min>
2
3CREATE TABLE IF NOT EXISTS `kv` (
4  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
5  `word` varchar(100) NOT NULL,
6  `mean` varchar(300) NOT NULL,
7  `value` bigint(20) NOT NULL,
8  PRIMARY KEY (`id`)
9);
10
11use databasename;
12
13DELIMITER $$
14DROP PROCEDURE IF EXISTS `kv_gen`$$
15CREATE PROCEDURE `kv_gen`(IN num_rows BIGINT)
16  BEGIN
17   DECLARE x INT;
18   DECLARE v INT;
19   
20   SET x = 1;
21   
22   WHILE x  <= num_rows DO     
23     SET v = FLOOR(RAND() * (10000 - 50 + 1)) + 50;
24     insert into kv(`word`, `mean`, `value`) VALUES('a','a mean',v);
25     SET  x = x + 1;
26   END WHILE;
27END$$
28DELIMITER ;
29
30call kv_gen(99999);