主鍵重復(fù)依然可以插入
+ (void)insertWithSetKeyName:(NSString *)keyName Value:(NSString *)value;
{
[self ?open];
NSString * sql = [NSString stringWithFormat:@"insert or ignore into PTBBSet values ('%@', '%@')", keyName, value];
sqlite3_exec(dbPoint, sql.UTF8String,NULL,NULL,NULL);
}
數(shù)據(jù)庫去重
select distinct name from table
數(shù)據(jù)庫模糊查詢
select * from table1 where field1 like ’%value1%’
數(shù)據(jù)庫多條件查詢 并且
select * from ?table?where name = '%@' and age = '%ld'
數(shù)據(jù)庫多條件查詢 或者
select * from? table where name = '%@' ?or?age = '%ld'
數(shù)據(jù)庫去重查詢
select ?distinct?name ?from ?table
查找并排序 ?asc正序? desc倒序
SELECT * FROM TABLE ORDER BY field1?DESC
查詢記錄總數(shù)
SELECT COUNT(*) FROM TABLE
查詢最大的
SELECT MAX(age) FROM TABLE
查詢最小的?
SELECT MIN(age) FROM? TABLE;
數(shù)據(jù)庫求和
select sum(field1) as sumvalue from table
數(shù)據(jù)庫取前10條
SELECT *FROM table LIMIT 10
數(shù)據(jù)庫跳過前面3條取3條數(shù)據(jù)
SELECT *FROM table LIMIT 6,3
