推荐一个零声学院免费公开课程,个人觉得老师讲得不错,分享给大家:Linux,Nginx,ZeroMQ,MySQL,Redis,fastdfs,MongoDB,ZK,流媒体,CDN,P2P,K8S,Docker,TCP/IP,协程,DPDK等技术内容,立即学习
1.IF语句
IF condition(x=1) THEN
(SELECT 1;)
ELSEIF condition(x=2) THEN
(SELECT 2;)
ELSE
(SELECT 3;)
END IF;
2.CASE语句
CASE valu(x)
WHEN value(1) TNEN SELECT 1;
WHEN value(2) TNEN SELECT 2;
ELSE …
END CASE;
3.WHILE语句
lable:WHILE i<100 DO
SET s=s+i;
SET i=i+1;
IF i=50 THEN
–退出while循环
LEAVE lable
END IF;
END WHILE;
4.LOOP语句
loop_label:LOOP
SET s=s+1;
SET i=i+1;
IF i>100 THEN
–推出LOOP循环
LEAVE loop_label;
END IF;
END LOOP;
5.REPEAT语句
REPEAT
SET s=s+i;
SET i=i+1;
UNTIL i>100
END REPEAT;
5.ITERATE语句
IF(i mod 2) THEN
SET s=s+1;
ELSE
–退出本次循环,继续下一个循环
ITERATE loop_bale;
END IF;