开发者

Android SQLite data Aceess of a null value attribute

开发者 https://www.devze.com 2023-03-23 07:21 出处:网络
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\'

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

精彩评论

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