创建一个测试表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代表升序