DROP PROCEDURE IF EXISTS `add_data` ;
DELIMITER ;;
CREATE PROCEDURE `add_data`(IN n INT)
BEGIN
DECLARE i INT DEFAULT 1;
DECLARE t_int INT DEFAULT 0;
DECLARE t_s_int INT DEFAULT 0;
DECLARE t_var varchar(100) DEFAULT '';
DECLARE randStr varchar(100) DEFAULT 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';
DECLARE resultStr varchar(255) DEFAULT '';
WHILE i < n DO
SET t_s_int = FLOOR(RAND() * 100);
SET t_int = unix_timestamp(now()) +FLOOR(RAND()*10000);
SET resultStr=CONCAT(SUBSTR(randStr,FLOOR(RAND()*LENGTH(randStr))+1,1),resultStr);
SET t_var = resultStr;
INSERT INTO `test` VALUES (NULL, t_int, t_s_int, t_var, NOW());
SET i = i + 1;
END WHILE;
END
;;
DELIMITER ;;
CREATE PROCEDURE `add_data`(IN n INT)
BEGIN
DECLARE i INT DEFAULT 1;
DECLARE t_int INT DEFAULT 0;
DECLARE t_s_int INT DEFAULT 0;
DECLARE t_var varchar(100) DEFAULT '';
DECLARE randStr varchar(100) DEFAULT 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';
DECLARE resultStr varchar(255) DEFAULT '';
WHILE i < n DO
SET t_s_int = FLOOR(RAND() * 100);
SET t_int = unix_timestamp(now()) +FLOOR(RAND()*10000);
SET resultStr=CONCAT(SUBSTR(randStr,FLOOR(RAND()*LENGTH(randStr))+1,1),resultStr);
SET t_var = resultStr;
INSERT INTO `test` VALUES (NULL, t_int, t_s_int, t_var, NOW());
SET i = i + 1;
END WHILE;
END
;;
DELIMITER ;
call add_data(5212010);