.jpg)
1、where循環(huán)
create?procedure?p_addnum() begin declare?i?int?default?1; declare?addresult?int?default?0; while?i?<p>2、repeat循環(huán)</p><pre class="brush:sql;toolbar:false">create?procedure?p_updatenum() begin declare?imin?int?default?1; declare?value?int?default?1; declare?imax?int?default?100; repeat select?value; set?value?=?value?+?1; set?imin?=?imin?+?1; until?imin?>?imax end?repeat; end; $$;
3、loop循環(huán)
create?procedure?p_updateloop() begin declare?imin?int?default?1; declare?value?int?default?1; declare?imax?int?default?100; myloop:loop select?value; set?value?=?value?+?1; set?imin?=?imin?+?1; if?imin?>?imax?then leave?myloop; end?if; end?loop; end; $$;
?以上就是MySQL高級(jí)三——循環(huán)語(yǔ)句的內(nèi)容，更多相關(guān)內(nèi)容請(qǐng)關(guān)注PHP中文網(wǎng)（www.php.cn）！
? 版權(quán)聲明
文章版權(quán)歸作者所有，未經(jīng)允許請(qǐng)勿轉(zhuǎn)載。
THE END
.png)
