sqlite的空值查询怎么写,能者得分
------解决方案--------------------------------------------------------
select * from tt where f1 is null
------解决方案--------------------------------------------------------
select * from yourTable where col is null;
------解决方案--------------------------------------------------------
- SQL code
sqlite> create table Aoqun (id int primary key,col1 int);sqlite> insert into Aoqun values (1,10);sqlite> insert into Aoqun values (2,null);sqlite>sqlite> select * from Aoqun;1|102|sqlite> select * from Aoqun where col1 is null;2|sqlite>
------解决方案--------------------------------------------------------
is null