查询某字段为空的数据时,不能用 = null或 !=null 错误示范(查不出数据) select * from table where column != null; 正确示范 select * from table where column is not null; select * from table where column is null;