条件判断函数

最新推荐文章于 2023-04-05 14:05:10 发布

2015_thinker

最新推荐文章于 2023-04-05 14:05:10 发布

阅读量392

点赞数

分类专栏：数据库文章标签： mysql 函数

本文链接：https://blog.csdn.net/u012412427/article/details/48226173

版权

数据库专栏收录该内容

13 篇文章 0 订阅

订阅专栏

ysql> select if(1>2,2,3);
+-------------+
| if(1>2,2,3) |
+-------------+
|           3 |
+-------------+
1 row in set (0.00 sec)

mysql> select if(1<2,'yes','no');
+--------------------+
| if(1<2,'yes','no') |
+--------------------+
| yes                |
+--------------------+
1 row in set (0.00 sec)

mysql> select if(strcmp('test','test1'),'no','yes');
+---------------------------------------+
| if(strcmp('test','test1'),'no','yes') |
+---------------------------------------+
| no                                    |
+---------------------------------------+
1 row in set (0.00 sec)

mysql> select ifnull(1,2),ifnull(null,10),ifnull(1/0,'wrong');
+-------------+-----------------+---------------------+
| ifnull(1,2) | ifnull(null,10) | ifnull(1/0,'wrong') |
+-------------+-----------------+---------------------+
|           1 |              10 | wrong               |
+-------------+-----------------+---------------------+
1 row in set (0.00 sec)

mysql> select case 2 when 1 then 'one' when 2 then 'two' else 'more end;
    '> '
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql> 
mysql> select case 2 when 1 then 'one' when 2 then 'two' else 'more' end;
+------------------------------------------------------------+
| case 2 when 1 then 'one' when 2 then 'two' else 'more' end |
+------------------------------------------------------------+
| two                                                        |
+------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select case 2.5 when 1 then 'one' when 2 then 'two' else 'more' end;
+--------------------------------------------------------------+
| case 2.5 when 1 then 'one' when 2 then 'two' else 'more' end |
+--------------------------------------------------------------+
| more                                                         |
+--------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select case 2.5 when 1 then 'one' when 2.5 then 'two' else 'more' end;
+----------------------------------------------------------------+
| case 2.5 when 1 then 'one' when 2.5 then 'two' else 'more' end |
+----------------------------------------------------------------+
| two                                                            |
+----------------------------------------------------------------+
1 row in set (0.00 sec)

mysql>