mysql流程函数

最新推荐文章于 2024-06-29 13:56:33 发布

黄宝康

最新推荐文章于 2024-06-29 13:56:33 发布

阅读量324

点赞数 1

分类专栏： mysql 文章标签： mysql流程函数

本文链接：https://blog.csdn.net/huangbaokang/article/details/84992828

版权

mysql 专栏收录该内容

128 篇文章 1 订阅

订阅专栏

在这里插入图片描述

直接看演示代码：

mysql> select if(100<200,'100小于200','你该上幼儿园了');
+----------------------------------------------------+
| if(100<200,'100小于200','你该上幼儿园了')          |
+----------------------------------------------------+
| 100小于200                                         |
+----------------------------------------------------+
1 row in set (0.00 sec)
mysql> select ifnull('','空字符串');
+---------------------------+
| ifnull('','空字符串')     |
+---------------------------+
|                           |
+---------------------------+
1 row in set (0.00 sec)

mysql> select ifnull(null,'空值');
+-----------------------+
| ifnull(null,'空值')   |
+-----------------------+
| 空值                  |
+-----------------------+
1 row in set (0.00 sec)
mysql> select case when 1 in (1,2,3) then '在范围之内' else '不在范围之内 ' end;
+------------------------------------------------------------------------------+
| case when 1 in (1,2,3) then '在范围之内' else '不在范围之内 ' end            |
+------------------------------------------------------------------------------+
| 在范围之内                                                                   |
+------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> select case 1+1 when 2 then '1+1=2' when 3 then '脑子进水' else '该上幼儿园了' end; 
+---------------------------------------------------------------------------------------+
| case 1+1 when 2 then '1+1=2' when 3 then '脑子进水' else '该上幼儿园了' end           |
+---------------------------------------------------------------------------------------+
| 1+1=2                                                                                 |
+---------------------------------------------------------------------------------------+
1 row in set (0.00 sec)