select
createTime,
lableState,
lableTime,
CASE lableState
WHEN 0 THEN '失败'
WHEN 1 THEN '成功'
WHEN 2 THEN '等待'
WHEN 3 THEN '人为强制终止'
WHEN 4 THEN '超时'
ELSE '异常结果'
END
Result
from drivice where lbMac=? ORDER BY id DESC
CASE判断
最新推荐文章于 2024-01-02 08:00:00 发布