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;