mysql 条件分支_sql_条件分支循环语句 | 学步园

===sqlserver:

---if语句：if(1+1=2)

print '对'

else

print '错'

---case-when-then语句：CREATE TABLE t_case(id INT,num INT)

go

INSERT INTO t_case VALUES(1,9),(2,10),(3,11);

go

SELECT 'level'=

CASE

WHEN num IS NULL THEN 'empty'

WHEN num<10 THEN 'less 10'

WHEN num>10 THEN 'great 10'

ELSE 'other'

END

FROM t_case WHERE id = 2;

---while语句：declare @i int

set @i=1

while(@i<=3)

begin

select @i

set @i=@i+1

end

-- 使用BREAK或CONTINUE可以跳出循环体

--if语句：

DELIMITER $$

DROP PROCEDURE IF EXISTS p_if$$

CREATE PROCEDURE p_if()

BEGIN -- 不同于sqlserver，if语句不能单独运行࿰