mysql流程控制函数

if 函数：if else 的后果

SELECT IF(10<5,"大","小"); #第一个表达式为真则返回第二个参数否则返回第三个
#案例:
SELECT 
    last_name,
    commission_pct,
    IF(commission_pct IS NULL,"没奖金","有奖金")
FROM 
    employees;SELECT IF(10<5,"大","小"); #第一个表达