sqlite的空值查询如何写,能者得分
sqlite的空值查询怎么写,能者得分
sqlite的空值查询怎么写,能者得分
------解决方案--------------------
select * from tt where f1 is null
------解决方案--------------------
select * from yourTable where col is null;
------解决方案--------------------
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|10 2| sqlite> select * from Aoqun where col1 is null; 2| sqlite>
------解决方案--------------------
is null