BEGIN
DECLARE count INT DEFAULT 10;
DECLARE js INT DEFAULT 0;
REPEAT #相当于DO-WHILE
SET count = count -1;
SET js = js+1;
UNTIL count<0 #符合条件就退出
END REPEAT;
SELECT js; #11
END
MySQL存储过程-REPEAT
最新推荐文章于 2024-07-28 21:35:44 发布