摘要：
select * from userinfo返回最后记录的序号select last_insert_rowid(); 创建视图create view schema as select * from sqlite_master;//创建索引CREATE INDEX test_idx on test (value)创建表CREATE TABLE sqlitenet_pictures ( UID INTEGER PRIMARY KEY AUTOINCREMENT,//主键 自增长 NAME VARCHAR(50), PICTURE BLOB ); 删除记录DELETE FROM foods WHER 阅读全文
