问题
使用 IFNULL(a.address,a.abbreviation) AS "address
语句不生效
因为 他只能判断null 没法判断空
转用 IF判断
https://blog.csdn.net/rocling/article/details/82147981 | MYSQL中可以实现类似IF判断的方法 |
---|---|
SELECT
t.NAME,
(
CASE t.sex
WHEN 1 THEN
'男'
WHEN 2 THEN
'女'
ELSE
'未知'
END
) 性别
FROM
t_customer t
<!-- 移动迁入场地 -->
<select id="selectMoveDealerSiteList" resultType="DealerSite">
SELECT
a.id AS "id",
a.dealer_id AS "dealerId",
a.type AS "type",
a.abbreviation