开发者

Android SQLite data Aceess of a null value attribute

I am working on my android project with SQLite database. I need to get all the information of the perons who doesn't have a phone. I tried with following thre开发者_StackOverflow社区e ways but didn't provide the required data. I have assign phone varchar(64), when create table.

select * from person where phone='null'
select * from person where phone=null
select * from person where phone=''

can anyone tell why is this happening and how can I get the information. Thanks


To query a null value use this sql statement:

select * from person where phone IS null
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜