sqlite基本语句使用
发布时间:2020-12-12 19:34:49 所属栏目:百科 来源:网络整理
导读:1 . 建表语句: NSString *sqlCrTable = [NSString stringWithFormat: @" CREATE TABLE IF NOT EXISTS '%@' ( '%@' INTEGER PRIMARY KEY AUTOINCREMENT, '%@' TEXT, '%@' TEXT) ",rollTableName,Id,ADPicURL,flag]; 2 . 插入数据: NSString *sqlAdd = [NSSt
1 . 建表语句: NSString *sqlCrTable = [NSString stringWithFormat:
@"CREATE TABLE IF NOT EXISTS '%@'('%@' INTEGER PRIMARY KEY AUTOINCREMENT,'%@' TEXT,'%@' TEXT)",rollTableName,Id,ADPicURL,flag];
2 . 插入数据: NSString *sqlAdd = [NSString stringWithFormat:
@"INSERT INTO '%@' ('%@','%@') VALUES ('%@','%@')",flag,imageName,(i == 2)?@"FIXED":@"SCROLL"];
3 . 查询数据: NSString *sqlQuery = [NSString stringWithFormat:
@"SELECT * FROM %@ order by ID limit %d",proTableName,kOnceCount]; // 只能这样取,不能用top, 一次取出几条数据
4 . 取出某值中间的数据: NSString *sqlQuery = [NSString stringWithFormat:
@" SELECT * FROM %@ where ID > %d order by ID limit %d",self.lastIndex,kOnceCount];
语句资料可参考:http://www.yiibai.com/sqlite/sqlite_sub_queries.html (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |