mysql 如何寫循環語句

--?設置mysql分隔符為//，也就意味著，當遇到下一個//時，整體執行SQL語句 DELIMITER?// ? DROP?PROCEDURE?if?EXISTS?‘test’;????#?如果存在test存儲過程則刪除 CREATE?procedure?test()?#?創建無參存儲過程，名稱為test BEGIN DECLARE?i?INT;??#?申明變量 SET?i?=?0;??#?變量賦值 WHILE?i<p>?</p><p>?</p><p>?</p><p>2.repeat循環</p><pre class="brush:php;toolbar:false">DELIMITER?// DROP?PROCEDURE?IF?EXISTS?test; CREATE?PROCEDURE?test() BEGIN ??DECLARE?i?INT; ??SET?i?=?0; ??REPEAT ????INSERT?INTO?test?VALUES(i+11,'test','20');??　　　　　　　　　#?往test表添加數據 ????SET?i?=?i?+?1;??????????????????????????????　　　　#?循環一次,i加一 ??UNTIL?i?&gt;?10?END?REPEAT;???????????????????????　　　　#?結束循環的條件:?當i大于10時跳出repeat循環 ??SELECT?*?FROM?test; END // CALL?test(); DELIMITER?;

DELIMITER?// DROP?PROCEDURE?IF?EXISTS?test; CREATE?PROCEDURE?test() BEGIN ??DECLARE?i?INT; ??SET?i?=?0; ????lp?:?LOOP???????????????????????????????　　　　#?lp為循環體名,可隨意?loop為關鍵字 ????????INSERT?INTO?test?VALUES(i+11,'test','20');　　　#?往test表添加數據 ????????SET?i?=?i?+?1;??????????????????????　　　　#?循環一次,i加一 ????????IF?i?>?10?THEN???????????????????　　　　#?結束循環的條件:?當i大于10時跳出loop循環 ????????????????????LEAVE?lp; ????????????END?IF; ????END?LOOP; ????SELECT?*?FROM?test; END // CALL?test(); DELIMITER?;