/**流程控制函数**/
# if(value,value1,value2) value 为 true 则value1 否则 value2
select if(1<0,true,false) from dual;
# ifnull(value1,value2) value1 为null1 ,则value2
select ifnull(null,true),ifnull(true,false) from dual;
# case expr when expr1 then value1 when expr2 then value2 else value3 end 理解为swich···case··· 语句
select case '2' when '3' then true when '4' then false else current_time() end from dual;
#case when expr then value when expr1 then value1 else value3 end 理解为 if···else if···else···
select case when 1<0 then true else '2' end from dual;
MySQL-流程控制函数
最新推荐文章于 2024-05-20 14:38:13 发布