DELIMITER $$
DROP PROCEDURE IF EXISTS `rr`.`ff`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `ff`()
BEGIN
declare i integer;
set i=1;
while i<=100 do
begin
insert into orders(hot) values(i);
SET I=I+1;
end;
end while;
END$$
DELIMITER ;
//调用存储过程。
call ff();