Mysql Case When 多列

最新推荐文章于 2023-04-01 16:03:46 发布

Haaaaaang

最新推荐文章于 2023-04-01 16:03:46 发布

阅读量1.4k

点赞数 1

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

本文链接：https://blog.csdn.net/java__project/article/details/109855563

版权

MySQL 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

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 ;