select
bankcardid,
bankname,
case
when isdefault=0 then '否'
when isdefault=1 then '是'
end as isdefault
from u_bankcard
where memberid=1001
转载于:https://www.cnblogs.com/caer/p/5682092.html
select
bankcardid,
bankname,
case
when isdefault=0 then '否'
when isdefault=1 then '是'
end as isdefault
from u_bankcard
where memberid=1001
转载于:https://www.cnblogs.com/caer/p/5682092.html