流程函数
| 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; |
本文链接：
本文章“java教程单行函数之流程函数”已帮助 284 人
免责声明：本信息由用户发布，本站不承担本信息引起的任何交易及知识产权侵权的法律责任！
本文由赋能网 整理发布。了解更多培训机构》培训课程》学习资讯》课程优惠》课程开班》学校地址等机构信息，可以留下您的联系方式，让课程老师跟你详细解答：
咨询热线：4008-569-579
