Mysql Case When 多列

最新推荐文章于 2024-06-25 17:37:52 发布

原创最新推荐文章于 2024-06-25 17:37:52 发布 · 1.5k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql

MySQL 专栏收录该内容

4 篇文章

订阅专栏

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

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 ;