sqlite的空值查询怎么写,能者得分
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