查询字段不为空时可以使用 IS NOT NULL
SELECT COUNT(*) FROM t_gpsinsurance WHERE gpsi_company='"+company+"' AND gpsi_createTime LIKE '"+day+"%' AND gpsi_gpsID IS NOT NULL
但是,有时我们查询 not null 时,在数据库中为空的也会被查询出来,呢么可以使用 <> “” 来查询。
SELECT COUNT(*) FROM t_gpsinsurance WHERE gpsi_company='"+company+"' AND gpsi_createTime LIKE '"+day+"%' AND gpsi_simID <>'';