Zhao_LingFei的博客

MySQL存储过程中游标循环的跳出和继续操作示例 MySQL中的游标循环操作常用的有三种,LOOP,REPEAT,WHILE.三种循环 1.REPEAT DECLARE num INT; DECLARE my_string VARCHAR(255); REPEAT SET my_string =CONCAT(my_string,num,','); SET num = num +1; UNTIL num <5 END REPEAT; 2.WHILE DECLARE num INT; DECL