流程函数
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
| IF(value,t ,f) | 如果value是真，返回t，否则返回f |
| IFNULL(value1, value2) | 如果value1不为空，返回value1，否则返回value2 |
| CASEWHEN 条件1 THEN result1WHEN 条件2 THEN result2….[ELSE resultn]END | 相当于Java的if…else if… |
| CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END | 相当于Java的switch |
| SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潜力股’WHEN salary>=8000 THEN ‘屌丝’ELSE ‘草根’ENDFROM t_employee; | |
| SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已发货’WHEN 4 THEN ‘确认收货’ELSE ‘无效订单’ENDFROM t_order; |
