摘录自:http://imysqldba.blog.51cto.com/1222376/595433
- 内循环变量在选环后要重新赋初值,否则不能循环。
- DELIMITER $$
- USE `qqfs_db_items`$$
- DROP PROCEDURE IF EXISTS `qqsf_proc_InsertItemTest`$$
- CREATE DEFINER=`root`@`%` PROCEDURE `qqsf_proc_InsertItemTest`(
- i_PlayerCount INT) COMMENT '插入道具表测试'
- BEGIN
- DECLARE a INT DEFAULT 1;
- DECLARE b TINYINT DEFAULT 1;
- WHILE (a <= i_PlayerCount) DO
- -- repeat
- SET a = a + 1;
- -- select a;
- WHILE (b <=40) DO
- INSERT INTO qqfs_tbl_items (AuthID,Slot,CID,GTID,Nums,Endtime,Flags,UseInfo)
- VALUES
- (a,b,0,0,1,NOW(),0,1);
- SET b = b + 1;
- -- select b;
- END WHILE;
- SET b = 1;
- -- select a;
- -- until a >= i_PlayerCount
- -- end repeat;
- END WHILE;
- END$$
- DELIMITER ;