【MySQL】SQL语句中有in的操作
select d.device_id,d.device_name,
(select d.dict_item_name from t_dict d where d.dict_type='device_type' and d.dict_item_id= d.device_type) device_type,
if(d.device_status='1','正常','故障') devi...
原创
2019-04-30 16:37:02 ·
582 阅读 ·
0 评论
关注
分享
扫一扫