delimiter //create procedure yourprocedurename()wholeblock:begin declare anyvariablename1 int ; declare anyvariablename3 int; declare anyvariablename2 varchar(255); set anyvariablename1 =1 ; set anyvariablename3 =10; set anyvariablename2 = '';loop_label: forloop if anyvariablename1 > anyvariablename3 then leave loop_label; end if; set anyvariablename2 = concat(anyvariablename2 ,anyvariablename1 ,','); set anyvariablename1 = anyvariablename1 + 1; iterate loop_label; end forloop;select anyvariablename2;end//
现在你可以实现上面的语法了。 for循环查询如下 -
mysql> delimiter //mysql> create procedure forloop() -> wholeblock:begin -> declare start int ; -> declare maxlimit int; -> declare result varchar(255); -> set start =1 ; -> set maxlimit=10; -> set result = ''; -> loop_label: loop -> if start > 10 then -> leave loop_label; -> end if; -> set result = concat(result,start,','); -> set start = start + 1; -> iterate loop_label; -> end loop; -> select result; -> end -> //query ok, 0 rows affected (0.37 sec)mysql> delimiter ;
上面的 for 循环打印 1 到 10，即采用以下形式 1,2,3,4,.....10。调用存储的使用 call 命令的过程。语法如下 -
call yourstoredprocedurename();
调用的查询如下 -
mysql> call forloop();
输出+-----------------------+| result |+-----------------------+| 1,2,3,4,5,6,7,8,9,10, |+-----------------------+1 row in set (0.00 sec)query ok, 0 rows affected (0.01 sec)
以上就是如何在mysql存储过程中使用for loop？的详细内容。