表:
CREATE TABLE Reports (
_id INTEGER NOT NULL PRIMARY KEY,member_id INTEGER,
is_conf BOOLEAN,
name TEXT,
started INTEGER,
finished INTEGER,
description TEXT,
obj_id INTEGER NOT NULL,
FOREIGN KEY (obj_id) REFERENCES Objects (_id));
我要获取member_id = NULL
这里的数据。
但是查询写的好像不对
String sql = "SELECT _id, name FROM Reports WHERE member_id = NULL";
Cursor cursor = db.rawQuery(sql, null);