这是我的表格创建语句
create table *ContentTest* (
CID INTEGER PRIMARY KEY AUTOINCREMENT,
BID INTEGER NOT NULL,
CContent TEXT,
CStartPage INTEGER NOT NULL,
CLeaf BOOLEAN DEFAULT *false*,
CFather INTEGER
);
然后我执行insert
insert into *ContentTest*
(BID, CContent, CStartPage, CFather)
values
(1, "QNMLGB", 272, -1);
insert into *ContentTest*
(BID, CContent, CStartPage, CLeaf, CFather)
values
(1, "QNMLGB", 272, *true*, -1);
查询的时候我哭了
这还真的把true 和false给插进去了，有木有大神啊，求指教