mysql case的语法
2024-09-28 06:38:47
测试表:team
第一种语法:
CASE case_value
WHEN when_value THEN statement_list
[WHEN when_value THEN statement_list] ...
[ELSE statement_list]
END CASE
mysql> select * from team;
+------+
| name |
+------+
| a |
| b |
| c |
| d |
+------+
rows in set (0.00 sec) mysql> select case name when 'a' then 'aaa' when 'b' then 'bbb' when 'c' then 'ccc' when 'd' then 'ddd' end from team;
+------------------------------------------------------------------------------------------------+
| case name when 'a' then 'aaa' when 'b' then 'bbb' when 'c' then 'ccc' when 'd' then 'ddd' end |
+------------------------------------------------------------------------------------------------+
| aaa |
| bbb |
| ccc |
| ddd |
+------------------------------------------------------------------------------------------------+
rows in set (0.00 sec) mysql> select case name when 'a' then 'aaa' when 'b' then 'bbb' when 'c' then 'ccc' when 'd' then 'ddd' else 'eee' end from team;
+-----------------------------------------------------------------------------------------------------------+
| case name when 'a' then 'aaa' when 'b' then 'bbb' when 'c' then 'ccc' when 'd' then 'ddd' else 'eee' end |
+-----------------------------------------------------------------------------------------------------------+
| aaa |
| bbb |
| ccc |
| ddd |
+-----------------------------------------------------------------------------------------------------------+
rows in set (0.00 sec)
第二种语法:
CASE
WHEN search_condition THEN statement_list
[WHEN search_condition THEN statement_list] ...
[ELSE statement_list]
END CASE
mysql> select (case when name='a' then 'aaa' when name='b' then 'bbb' when name='c' then 'ccc' when name='d' then 'ddd' else 'ccc' end) alias from team;
+-------+
| alias |
+-------+
| aaa |
| bbb |
| ccc |
| ddd |
+-------+
rows in set (0.00 sec)
最新文章
- 【转】我的技术学习方法 — Anytao
- Windows简单几步实现系统自动关机设置
- 一个jsonp的简单实例
- ubuntu grub配置
- The test form is only available for requests from the local machine 解决方法
- ZigZag-LeetCode
- 动态规划——最长公共子序列(LCS)
- 【freeradius3】安装和拓展需求
- CentOS 7 系统下 GitLab 搭建
- C语言中类型转换#大写字母转小写字母和小写字母转大写字母案例。
- js获取css样式封装
- Github(远程仓库) 2
- 【工具相关】Web-HTML特殊字符对照表
- Go学习入门
- Generate class from database table How can i generate a class from a table at a SQL Server?
- Terminal run py文件
- 汽车车牌JS正则表达式验证(含新能源车牌)
- Java字符串分割
- double 和 im2double 的区别
- easyui datagrid种编辑器combobox选择的值不显示解决方案