Mysql每日一题（if函数）

 

两种写法if()和case

if()函数

select *,if(T.x+T.y>T.z and T.x+T.z>T.y and T.y+T.z>T.x,'Yes','No') as 'triangle'
from Triangle as T;

case方法

select *, case
when T.x+T.y>T.z and T.x+T.z>T.y and T.y+T.z>T.x then 'Yes'
else 'No' end as 'triangle'
from Triangle as T;