最近想在运行sql 时执行一些判断输出结果,在网上找了很久,其实用case then end 就可以了,下面是例子
SELECT
t1.imei AS `唯一设备码`,
t1.familyname AS `商家名称`,
t1.address AS `地址`,
case
when t1.is_bind =0 THEN '未激活'
when t1.is_bind=1 THEN ' 激活'
else '未知'
end
as `设备状态`,
from_unixtime(
t1.bindtime,
'%Y-%m-%d %H:%i:%s'
) AS `绑定时间`
FROM
device t1
结果如下
如果有什么问题及不懂的可以于关注公众号 回复999加我微信交流下