mysql case实例：CASE WHEN with ELSE的用法

本节学习下mysql中case when else的用法，代码如下：

mysql> delimiter $$
mysql> CREATE PROCEDURE myProc(id int) //创建mysql存储过程
    -> BEGIN
    ->     CASE
    ->          WHEN id < 2  THEN
    ->               select 'less than 2';
    ->          WHEN id > 2 and id < 5 THEN
    ->               select 'greater than 2 and less than 5';
    ->          ELSE
    ->               select 'ELSE';
    ->     END CASE;
    -> END$$
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;
mysql> call myProc(1); //调用存储过程
+-------------+
| less than 2 |
+-------------+
| less than 2 |
+-------------+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

mysql>
mysql> call myProc(3); //调用存储过程
+--------------------------------+
| greater than 2 and less than 5 |
+--------------------------------+
| greater than 2 and less than 5 |
+--------------------------------+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> drop procedure myProc; //删除存储过程
Query OK, 0 rows affected (0.00 sec)

您可能感兴趣的文章：
mysql case实例：CASE WHEN with ELSE的用法
mysql case实例：带条件检测的case语句
mysql case实例：在存储过程中使用CASE WHEN语句
mysql case实例：在存储过程中使用CASE WHEN条件
mysql内置函数case用法介绍
mysql条件语句case when的实例
mysql数据库case语句的使用方法
mysql case实例：分组检测条件值
mysql的call用法 嵌套函数调用的例子
MYSQL数据库中ORDER BY CASE WHEN使用示例