当前位置: 代码迷 >> 综合 >> mybatis 如果返回值为空,设0
  详细解决方案

mybatis 如果返回值为空,设0

热度:48   发布时间:2024-01-16 08:42:51.0
SELECT CASE WHEN s1.online_status IS NOT NULL AND TRIM(s1.online_status)!='' THEN s1.online_status ELSE 0 END online_status  FROM server_config  c  LEFT JOIN  `cur_data_original` d on d.`key` = c.`key` left join server_status s1
  相关解决方案