创建表:
DROP TABLE IF EXISTS `students`;
CREATE TABLE `students` (
`s_id` int(11) NOT NULL AUTO_INCREMENT,
`s_name` varchar(100) DEFAULT NULL,
`s_age` int(11) DEFAULT NULL,
`s_phone` varchar(30) DEFAULT NULL,
PRIMARY KEY (`s_id`),
KEY `s_name` (`s_name`)
) ENGINE=InnoDB, CHARSET=utf8;
执行的函数:
CREATE PROCEDURE test_two()
BEGIN
DECLARE i INT DEFAULT 30000;
WHILE i < 100000 DO
INSERT into students(s_name, s_age, s_phone) VALUES ('aa', FLOOR(RAND() * 100), FLOOR(RAND() * 100000));
SET i = i+1;
end WHILE;
END;
CALL test_two();
说明:test_two() 每用一次需要变更。