mysql:数据库的流程控制语法：条件判断和循环

DROP PROCEDURE IF EXISTS no1;
-- 修改分隔符
DELIMITER //
CREATE PROCEDURE no1(a INT, b INT, label VARCHAR(3)) 
BEGIN 

     -- if, 条件选择结构
--   if label = '+' then
--      set a = a + b;
--   elseif label = '-' then
--      SET a = a - b;
--   else
--      SET a = a * b;
--   end if;

     -- case, 等值选择/条件选择
/*     case label
     when '+' then 
       set a = a + b;
     when '-' then
       set a = a - b;
     else
       set a = a * b;
     end case;
*/
/*     case
     when label = '+' then
       set a = a + b;
     WHEN label = '-' THEN
       SET a = a - b;
     else
       SET a = a * b;
     end case;  
*/ 
     DECLARE SUM INT;
     SET SUM = 0;
     -- while循环
     /*while a < b do
       set sum = sum + a;
       set a = a + 1;
     end while;*/
     
     -- repeat循环
     /*repeat
     set sum = sum + a;
     set a = a + 1;
     until a > 100
     end repeat;*/
     
     -- loop循环
     loop1:LOOP
     SET SUM = SUM + a;
     IF a > b THEN LEAVE loop1;
     END IF;
     SET a = a + 1;
     END LOOP loop1;
     
  SELECT SUM;
END;
// 
DELIMITER ;

CALL no1(1, 100, '+');