.jpg)
在學(xué)習(xí)MySQL的時(shí)候，我們需要知道些什么，要注意哪些問(wèn)題，下面我們來(lái)介紹 MySQL 的 Iterate 迭代語(yǔ)句。
mysql> mysql> mysql>?DELIMITER?// mysql>?CREATE?PROCEDURE?myProc?(IN?in_count?INT) ????->?BEGIN ????->?????DECLARE?count?INT?default?0; ????-> ????->?????increment:?LOOP ????->?????SET?count?=?count?+?1; ????->?????IF?count??????IF?count?>?in_count?THEN?LEAVE?increment; ????->?????END?IF; ????->?????END?LOOP?increment; ????-> ????->?????SELECT?count; ????->?END ????->?// Query?OK,?0?rows?affected?(0.00?sec) mysql>?DELIMITER?; mysql> mysql>?call?myProc(5); +-------+ |?count?| +-------+ |????20?| +-------+ 1?row?in?set?(0.00?sec) Query?OK,?0?rows?affected?(0.00?sec) mysql> mysql>?drop?procedure?myProc; Query?OK,?0?rows?affected?(0.00?sec) mysql>
? 版權(quán)聲明
文章版權(quán)歸作者所有，未經(jīng)允許請(qǐng)勿轉(zhuǎn)載。
THE END
.png)
