数据库中查询出空值null设置为0

select s1.company company,IFNULL(s1.department,0) department,s1.position position,s1.name person,IFNULL(s2.oneLevel,0) oneLevel,

posted @ 2021-01-06 11:23  DFrank001  阅读(472)  评论(0)  编辑  收藏  举报