Mysql Case When 多列

Haaaaaang

于 2020-11-20 17:17:05 发布

阅读量1.5k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： MySQL 文章标签： mysql

本文链接：https://blog.youkuaiyun.com/java__project/article/details/109855563

MySQL 专栏收录该内容

4 篇文章

订阅专栏

本文介绍了一个SQL查询案例，用于从数据库中检索特定租户和实体的属性配置详情，包括属性名称、显示名称、数据类型等关键信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT a.api_key AS '属性名称',
       a.label AS '属性显示名称',
       CASE
           WHEN a.item_type = 1 THEN '文本'
           WHEN a.item_type = 2 THEN '布尔型'
           WHEN a.item_type = 4 THEN '单选'
           WHEN a.item_type = 5 THEN '整型'
           WHEN a.item_type = 6 THEN '实数'
           WHEN a.item_type = 7 THEN '长整型'
           WHEN a.item_type = 8 THEN '日期'
           WHEN a.item_type = 9 THEN '时间'
           WHEN a.item_type = 10 THEN 'ID'
           ELSE ''
       END AS '数据类型',
       CASE
           WHEN a.is_member_only = 1 THEN '是'
           WHEN a.is_member_only = 0 THEN '否'
           ELSE ''
       END AS '会员专用',
       CASE
           WHEN a.hidden_flg = 1 THEN '隐藏'
           WHEN a.hidden_flg = 0 THEN '显示'
           ELSE ''
       END AS '显示状态',
       CASE
           WHEN a.require_flg = 1 THEN '是'
           WHEN a.require_flg = 0 THEN '否'
           ELSE ''
       END AS '是否必填',
       CASE
           WHEN a.sort_flg = 1 THEN '是'
           WHEN a.sort_flg = 0 THEN '否'
           ELSE ''
       END AS '是否分组',
       CASE
           WHEN a.description IS NULL THEN ''
           ELSE a.description
       END AS '属性值事例或说明'
FROM cdp_item a
WHERE tenant_id = 1216983876421894
  AND entity_id = 658
  AND created_by = 1345805699270860 ;