Android sqlite常见sql语句

创建一个测试表man：

select * from man;

 查询man表所有信息：

select * from man where name like '%四';

//删除操作
delete from man where name = 'lucy2';
//部分字段查询
select name,weight from man;
select * from man where age > 25 or weight > 90;

select * from man where name like 'l%';

 %代表任意个字符

select * from man where name like 'l___';

 _代表占位符，一个占一位

select * from man where name glob '*e?';

 ?代表一个占位符，*代表任意字符串

select * from man where name glob 'l*';

 glob模糊搜索时大小写敏感

select * from man limit 3 offset 4;

 limit和offset配合可应用于数据库分页

select * from man order by age desc;

 desc代表降序

select * from man order by age asc;

 asc代表升序