Android Sqlite数据库常用语句整理

1.创建表的操作

create table 表名（字段名 数据类型(限制)…）create table person(_id Integer primary key,name varchar(10),age Integer);

2.删除表

drop table 表名drop table person;

3.插入数据

insert into 表名(字段…) values(字段的值…)insert into person (_id,name) values (1,'xxx');insert into person values (2,'xxx',30);

4.`修改数据

update 表名 set字段名=新值 where 修改条件update person set name='lee' where _id=1;update person set name='lucy',age=18 where _id=2;

5.删除数据

delete from 表名 where 删除条件delete from person where _id=2;

6.查询数据

selete 字段列表 from 表名 where 条件 having 筛选条件 group by 分组字段 order by 排序字段selete _id,name from person;selete * from person;selete * from person where _id=3;selete * from person where _id>1 and age>25;selete * from person where age between 18 and 25;selete * from person where age in(20,30);selete * from person where name like '%红%';selete * from person where _id>10 order by age desc;