有5种方法进行查询:
isnull()select * from users where email = xxxx and isnull(deletedAt)
is nullselect * from users where email = xxxx and deletedAt is null
is not nullselect * from users where email = xxxx and deletedAt is not null
!isnull()select * from users where email = xxxx and !isnull(deletedAt)
select * from users where email = xxxx and not isnull(deletedAt)
isfull
当查询条件为 null,用指定字符替代select name, isfull(gender,未知) as gender from users where email = xxxx
如果觉得《mysql字段空值在前端怎么检验 – 数据库 – 前端 mysql sql语句 in》对你有帮助,请点赞、收藏,并留下你的观点哦!