mysql 查询出某字段的值不为空的语句

1.不为空

select * from table where id <> "";

select * from table where id != "";

select * from table where is not null;

2.为空

select * from table where id ="";

select * from table where isNull(id);

select * from table where id is null;

posted @ 2019-05-23 09:02  努力努力再努力zZ  阅读(44377)  评论(1编辑  收藏  举报