MySQL瀛樺偍杩囩▼涓殑三绉嶅惊鐜_mysql

mysql瀛樺偍杩囩▼涓殑3绉嶅惊鐜?

杞嚜锛?a target=”_blank” href=”http://blog.sina.com.cn/s/blog_4f925fc30100mw2l.html” title=”鐐瑰嚮鏌ョ湅鍘熸枃”>http://blog.sina.com.cn/s/blog_4f925fc30100mw2l.html

聽

聽聽鍦∕ySQL瀛樺偍杩囩▼鐨勮鍙ヤ腑鏈変笁涓爣鍑嗙殑寰幆鏂瑰紡锛歐HILE寰幆锛孡OOP寰幆浠ュ強REPEAT寰幆銆傝繕鏈変竴绉嶉潪鏍囧噯鐨勫惊鐜柟寮忥細GOTO锛屼笉杩囪繖绉嶅惊鐜柟寮忔渶濂藉埆鐢紝寰堝鏄撳紩璧风▼搴忕殑娣蜂贡锛屽湪杩欓噷灏变笉閿欏叿浣撲粙缁嶄簡銆?/p>

杩欏嚑涓惊鐜鍙ョ殑鏍煎紡濡備笅锛?br>WHILE鈥︹€O鈥︹€ND WHILE
REPEAT鈥︹€NTIL END REPEAT
LOOP鈥︹€ND LOOP
GOTO銆?/p>

聽

聽聽聽聽涓嬮潰棣栧厛浣跨敤绗竴绉嶅惊鐜紪鍐欎竴涓緥瀛愩€?br>mysql> create procedure pro10()
聽聽聽聽-> begin
聽聽聽聽-> declare i int;
聽聽聽聽-> set i=0;
聽聽聽聽-> while i<5 do
聽聽聽聽->聽聽聽聽聽insert into t1(filed) values(i);
聽聽聽聽->聽聽聽聽聽set i=i+1;
聽聽聽聽-> end while;
聽聽聽聽-> end;//
Query OK, 0 rows affected (0.00 sec)
聽聽聽聽鍦ㄨ繖涓緥瀛愪腑锛孖NSERT鍜孲ET璇彞鍦╓HILE鍜孍ND WHILE涔嬮棿锛屽綋鍙橀噺i澶т簬绛変簬5鐨勬椂鍊欏氨閫€鍑哄惊鐜€備娇鐢╯et i=0锛涜鍙ユ槸涓轰簡闃叉涓€涓父瑙佺殑閿欒锛屽鏋滄病鏈夊垵濮嬪寲锛宨榛樿鍙橀噺鍊间负NULL锛岃€孨ULL鍜屼换浣曞€兼搷浣滅殑缁撴灉閮芥槸NULL銆?br>聽聽聽聽鎵ц涓€涓嬭繖涓瓨鍌ㄨ繃绋嬪苟浜х湅涓€涓嬫墽琛岀粨鏋滐細
mysql> delete from t1//
Query OK, 0 rows affected (0.00 sec)
mysql> call pro10()//
Query OK, 1 row affected (0.00 sec)
mysql> select * from t1//
+鈥斺€?+
| filed |
+鈥斺€?+
|聽聽聽聽聽0 |
|聽聽聽聽聽1 |
|聽聽聽聽聽2 |
|聽聽聽聽聽3 |
|聽聽聽聽聽4 |
+鈥斺€?+
5 rows in set (0.00 sec)
聽聽聽聽浠ヤ笂灏辨槸鎵ц缁撴灉锛屾湁5琛屾暟鎹彃鍏ュ埌鏁版嵁搴撲腑锛岃瘉鏄庡瓨鍌ㄨ繃绋嬬紪鍐欐纭棤璇痎_^銆?/p>

聽聽聽聽鍐嶆潵鐪嬩竴涓嬬浜屼釜寰幆鎺у埗鎸囦护 REPEAT鈥︹€ND REPEAT銆備娇鐢≧EPEAT寰幆鎺у埗璇彞缂栧啓涓嬮潰杩欎釜瀛樺偍杩囩▼锛?br>mysql> create procedure pro11()
聽聽聽聽-> begin
聽聽聽聽-> declare i int default 0;
聽聽聽聽-> repeat
聽聽聽聽->聽聽聽聽聽insert into t1(filed) values(i);
聽聽聽聽->聽聽聽聽聽set i=i+1;
聽聽聽聽->聽聽聽聽聽until i>=5
聽聽聽聽-> end repeat;
聽聽聽聽-> end;//
Query OK, 0 rows affected (0.00 sec)
聽聽聽聽杩欎釜REPEAT寰幆鐨勫姛鑳藉拰鍓嶉潰WHILE寰幆涓€鏍凤紝鍖哄埆鍦ㄤ簬瀹冪殑鎵ц鍚庢鏌ユ槸鍚︽弧瓒冲惊鐜潯浠讹紙until i>=5锛夛紝鑰學HILE鍒欐槸鎵ц鍓嶆鏌ワ紙while i<5 do锛夈€?br>聽聽聽聽涓嶈繃瑕佹敞鎰弖ntil i>=5鍚庨潰涓嶈鍔犲垎鍙凤紝濡傛灉鍔犲垎鍙凤紝灏辨槸鎻愮ず璇硶閿欒銆?br>聽聽聽聽缂栧啓瀹屾垚鍚庯紝璋冪敤涓€涓嬭繖涓瓨鍌ㄨ繃绋嬶紝骞舵煡鐪嬬粨鏋滐細
mysql> delete from t1//
Query OK, 5 rows affected (0.00 sec)

mysql> call pro11()//
Query OK, 1 row affected (0.00 sec) #铏界劧鍦ㄨ繖閲屾樉绀哄彧鏈変竴琛屾暟鎹彈鍒板奖鍝嶏紝浣嗘槸涓嬮潰閫夋嫨鏁版嵁鐨勮瘽锛岃繕鏄彃鍏ヤ簡5琛屾暟鎹€?/p>

鍐嶆潵鐪嬩竴涓嬬涓変釜寰幆鎺у埗璇彞LOOP鈥︹€ND LOOP銆傜紪鍐欎竴涓瓨鍌ㄨ繃绋嬬▼搴忓涓嬶細
mysql> create procedure pro12()
聽聽聽聽-> begin
聽聽聽聽-> declare i int default 0;
聽聽聽聽-> loop_label: loop

聽

聽聽聽聽->聽聽聽聽聽insert into t1(filed) values(i);
聽聽聽聽->聽聽聽聽聽set i=i+1;
聽聽聽聽->聽聽聽聽聽if i>=5 then
聽聽聽聽->聽聽聽聽聽聽聽聽聽leave loop_label;
聽聽聽聽->聽聽聽聽聽end if;
聽聽聽聽-> end loop;
聽聽聽聽-> end;//
Query OK, 0 rows affected (0.00 sec)
浠庝笂闈㈣繖涓緥瀛愬彲浠ョ湅鍑猴紝浣跨敤LOOP缂栧啓鍚屾牱鐨勫惊鐜帶鍒惰鍙ヨ姣斾娇鐢╳hile鍜宺epeat缂栧啓鐨勮澶嶆潅涓€浜涳細鍦ㄥ惊鐜唴閮ㄥ姞鍏ヤ簡IF鈥︹€ND IF璇彞锛屽湪IF璇彞涓張鍔犲叆浜哃EAVE璇彞锛孡EAVE璇彞鐨勬剰鎬濇槸绂诲紑寰幆锛孡EAVE鐨勬牸寮忔槸锛歀EAVE 寰幆鏍囧彿銆?br>聽聽聽聽缂栧啓瀹屽瓨鍌ㄨ繃绋嬬▼搴忓悗锛屾潵鎵ц骞舵煡鐪嬩竴涓嬭繍琛岀粨鏋滐細
mysql> delete from t1//
Query OK, 5 rows affected (0.00 sec)

聽

mysql> call pro12//
Query OK, 1 row affected (0.00 sec) #铏界劧璇村彧鏈変竴琛屾暟鎹彈褰卞搷锛屼絾鏄疄闄呬笂鏄彃鍏ヤ簡5琛屾暟鎹€?/p>

聽聽聽Labels聽聽聽鏍囧彿鍜?END Labels 缁撴潫鏍囧彿
聽聽聽鍦ㄤ娇鐢╨oop鐨勬椂鍊欙紝浣跨敤鍒扮殑labels鏍囧彿锛屽浜巐abels鍙互鐢ㄥ埌while锛宭oop锛宺repeat绛夊惊鐜帶鍒惰鍙ヤ腑銆傝€屼笖鏈夊繀瑕佸ソ濂借璇嗕竴涓媗ables!锛?br>mysql> create procedure pro13()
聽聽聽聽-> label_1:begin
聽聽聽聽-> label_2:while 0=1 do leave label_2;end while;
聽聽聽聽-> label_3:repeat leave label_3;until 0=0 end repeat;
聽聽聽聽-> label_4:loop leave label_4;end loop;
聽聽聽聽-> end;//
Query OK, 0 rows affected (0.00 sec)
聽聽聽聽涓婇潰杩欓噷渚嬪瓙鏄剧ず浜嗗彲浠ュ湪BEGIN銆乄HILE銆丷EPEAT鎴栬€匧OOP璇彞鍓嶄娇鐢ㄨ鍙ユ爣鍙凤紝璇彞鏍囧彿鍙兘鍦ㄥ悎娉曠殑璇彞鍓嶄娇鐢紝鎵€浠EAVE label_3鎰忓懗鐫€绂诲紑璇彞鏍囧彿鍚嶄负label_3鐨勮鍙ユ垨绗﹀悎璇彞銆?br>聽聽聽聽鍏跺疄锛屼篃鍙互浣跨敤END labels鏉ヨ〃绀烘爣鍙风粨鏉熺銆?br>mysql> create procedure pro14()
聽聽聽聽-> label_1:begin
聽聽聽聽-> label_2:while 0=1 do leave label_2;end while label_2;
聽聽聽聽-> label_3:repeat leave label_3;until 0=0 end repeat label_3;
聽聽聽聽-> label_4:loop leave label_4;end loop label_4;
聽聽聽聽-> end label_1;//
Query OK, 0 rows affected (0.00 sec)
聽聽聽聽涓婇潰灏辨槸浣跨敤浜嗘爣鍙风粨鏉熺锛屽叾瀹炶繖涓粨鏉熸爣鍙峰苟涓嶆槸鍗佸垎鏈夌敤锛岃€屼笖浠栧繀椤诲拰寮€濮嬪畾涔夌殑鏍囧彿鍚嶅瓧涓€鏍凤紝鍚﹀垯灏变細鎶ラ敊銆傚鏋滆鍏绘垚涓€涓壇濂界殑缂栫▼涔犳儻鏂逛究浠栦汉闃呰鐨勮瘽锛屽彲浠ヤ娇鐢ㄨ繖涓爣鍙风粨鏉熺銆?/p>

ITERATE 杩唬聽聽聽聽聽聽聽聽
聽聽聽聽聽濡傛灉鏄湪ITERATE璇彞锛屽嵆杩唬璇彞涓殑璇濓紝灏卞繀椤讳娇鐢↙EAVE璇彞銆侷TERATE鍙兘鍑虹幇鍦↙OOP锛孯EPEAT鍜學HILE璇彞涓紝瀹冪殑鎰忔€濇槸鈥滃啀娆″惊鐜€濓紝渚嬪锛?br>mysql> create procedure pro15()

聽

聽聽聽聽-> begin
聽聽聽聽-> declare i int default 0;
聽聽聽聽-> loop_label:loop
聽聽聽聽->聽聽聽聽聽if i=3 then
聽聽聽聽->聽聽聽聽聽聽聽聽聽set i=i+1;
聽聽聽聽->聽聽聽聽聽聽聽聽聽iterate loop_label;
聽聽聽聽->聽聽聽聽聽end if;
聽聽聽聽->聽聽聽聽聽insert into t1(filed) values(i);
聽聽聽聽->聽聽聽聽聽set i=i+1;
聽聽聽聽->聽聽聽聽聽if i>=5 then
聽聽聽聽->聽聽聽聽聽聽聽聽leave loop_label;
聽聽聽聽->聽聽聽聽聽end if;
聽聽聽聽->聽聽聽end loop;
聽聽聽聽-> end;//
Query OK, 0 rows affected (0.00 sec)
聽聽聽聽iterate璇彞鍜宭eave璇彞涓€鏍凤紝涔熸槸鍦ㄥ惊鐜唴閮ㄤ娇鐢紝瀹冩湁鐐圭被浼间簬C/C++璇█涓殑continue銆?br>聽聽聽聽閭ｄ箞杩欎釜瀛樺偍绋嬪簭鏄€庝箞杩愯鐨勭殑锛熼鍏坕鐨勫€间负0锛屾潯浠跺垽鏂鍙f i=3 then鍒ゆ柇涓哄亣锛岃烦杩噄f璇锛屽悜鏁版嵁搴撲腑鎻掑叆0锛岀劧鍚巌+1锛屽悓鏍峰悗闈㈢殑if i>=5 then鍒ゆ柇涔熶负鍋囷紝涔熻烦杩囷紱缁х画寰幆锛屽悓鏍锋彃鍏?鍜?锛涘湪i=3鐨勬椂鍊欐潯浠跺垽鏂鍙f i=3 then鍒ゆ柇涓虹湡锛屾墽琛宨=i+1锛宨鍊间负4锛岀劧鍚庢墽琛岃凯浠terate loop_label;锛屽嵆璇彞鎵ц鍒癷terate loop_label;鍚庣洿鎺ヨ烦鍒癷f i=3 then鍒ゆ柇璇彞锛屾墽琛屽垽鏂紝杩欎釜鏃跺€欑敱浜巌=4锛宨f i=3 then鍒ゆ柇涓哄亣锛岃烦杩嘔F璇锛屽皢4娣诲姞鍒拌〃涓紝i鍙樹负5锛屾潯浠跺垽鏂璱f i>=5 then鍒ゆ柇涓虹湡锛屾墽琛宭eave loop_label;璺冲嚭loop寰幆锛岀劧鍚庢墽琛宔nd;//锛岀粨鏉熸暣涓瓨鍌ㄨ繃绋嬨€?br>聽聽聽聽缁间笂鎵€杩帮紝鏁版嵁搴撲腑灏嗘彃鍏ユ暟鍊硷細0,1,2,4銆傛墽琛屽瓨鍌ㄨ繃绋嬶紝骞舵煡鐪嬬粨鏋滐細|
mysql> delete from t1//
Query OK, 5 rows affected (0.00 sec)

聽

mysql> call pro15//
Query OK, 1 row affected (0.00 sec)

鍜屾垜浠笂闈㈠垎鏋愮殑缁撴灉涓€鏍凤紝鍙彃鍏ヤ簡鏁板€?,1,2,4銆?/p>

欢迎大家阅读《MySQL瀛樺偍杩囩▼涓殑三绉嶅惊鐜_mysql》,跪求各位点评，by 搞代码

搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]‍，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：MySQL瀛樺偍杩囩▼涓殑三绉嶅惊鐜_mysql

Hi，您需要填写昵称和邮箱！