FMDB , sqlite 查询语句

1.创建表:   表名:(tableName)

@"create table tableName(countID text primary key,name text, subject text)"

2.删除表:@"drop table tableName"

3.添加数据: 

@"insert into tableName(countID,name,subject) values (?,?,?)"

4.根据表中的某个id删除对应的数据: 

@"delete from tableName where countID = '01'"

5.选择表:

@"select * from tableName"

6.

//1 排序

//asc 默认 升序

//select * from %@ order by rowid desc 降序

//根据某个列名(rowid) 进行升序,降序排列

@"select * from tableName order by rowid asc"

7.根据某个列名(countID)来查询:

@"select * from tableName where countID"

8.查询表中一共有几条数据:

@"select count(*) from tableName"

9.查询在某个值区间的数据,根据列名(rowid)来查询  1 到 10 的数据:

@"select * from tableName where rowid between 1 and 10"

10.查询某个列名(countID)中的值有:

@"select * from %@ where countID = ?"

11.删除前10条数据  ,其中countID 为列名  ,  tableName为表名  ASC为升序

@"delete from tableName where (select count(countID) from tableName)> 1 and countID in (select countID from tableName order by countID ASC limit 10)"