while循环使用
CREATE DEFINER=`root`@`localhost` PROCEDURE `while_use`()BEGINdeclare sum int default 0;declare t int default 5;while t>0 doset sum=sum+1;set t=t-1;end while;SELECT sum;END
repeat用法:
CREATE DEFINER=`root`@`localhost` PROCEDURE `repeat_use`()begindeclare a int default 10;repeatset a=a-1;until a<5end repeat;select a;end
loop用法
CREATE DEFINER=`root`@`localhost` PROCEDURE `test_loop`()begindeclare t int default 0;label:loopset t=t+1;if t>10 then leave label;end if;end loop label;SELECT t;end