1 | 查询所有数据
select * from Info 查所有数据
select Code,Name from Info 查特定列
2 | 根据条件查
select * from Info where Code='p001' 一个条件查询
select * from Info where Code='p001' and Nation='n001' 多条件 并关系 查询
select * from Info where Name='胡军' or Nation='n001' 多条件 或关系 查询
select * from Car where Price>=50 and Price<=60 范围查询
select * from Car where Price between 50 and 60 范围查询
3 | 模糊查询
select * from Car where Name like '%型' %通配符代表任意多个字符
select * from Car where Name like '%奥迪%' _通配符代表任意一个字符
select * from Car where Name like '_马%'
4| 排序
select * from Car order by Price asc 按照价格升序排列
select * from Car order by Price desc 按照价格降序排列
select * from Car order by Price,Oil 按照两列进行排序,前面的为主要的
5 | 统计函数(聚合函数)
select count(Code) from Car 查询表中有多少条数据
select max(Price) from Car 取价格的最大值
select min(Price) from Car 取价格的最小值
select sum(Price) from Car 取价格的总和
select avg(Price) from Car 取价格的平均值
6 | 分组查询
select Brand from Car group by Brand having count(*)>2 查询所有系列中数量大于2的
7 | 分页查询
select * from Car limit 0,5 跳过几条数据取几条数据
8 | 去重查询
select distinct Brand from Car
文章来源: 松勤网
兄弟文案高质量:https://www.nanss.com/wenan/1612.html
感恩语录经典短句:https://www.nanss.com/yulu/21.html
人生最好状态正能量经典语录:https://www.nanss.com/shenghuo/1608.html
表达最近不顺的朋友圈:https://www.nanss.com/wenan/1593.html
形容自己永远是外人的句子:https://www.nanss.com/yulu/1569.html
阿里云常见的操作命令记录:https://www.nanss.com/blog/1792.html
情侣名字一对:https://www.nanss.com/mingcheng/1817.html
粗茶淡饭朋友圈说说:https://www.nanss.com/wenan/1845.html
男生好听的网名:https://www.nanss.com/mingcheng/809.html
帮会名字既文雅又霸气:https://www.nanss.com/mingcheng/663.html
昵称女:https://www.nanss.com/mingcheng/902.html
有文化高雅内涵的网名:https://www.nanss.com/mingcheng/897.html
70后网名:https://www.nanss.com/mingcheng/1471.html
很深奥的备注:https://www.nanss.com/mingcheng/1672.html
霸道的网名:https://www.nanss.com/mingcheng/1367.html
霸气的网名:https://www.nanss.com/mingcheng/988.html
比较好的微信号id号:https://www.nanss.com/mingcheng/907.html
爸爸生日幽默说说:https://www.nanss.com/wenan/1857.html
我的大学生活英语作文:https://www.nanss.com/xuexi/845.html
男生霸气网名:https://www.nanss.com/mingcheng/1218.html
心属一人的网名:https://www.nanss.com/mingcheng/1619.html
退房申请书:https://www.nanss.com/shenghuo/2456.html
最能感动老婆的早安情话:https://www.nanss.com/yulu/1661.html
墙角的垃圾:https://www.nanss.com/xuexi/2062.html
面对困难的励志的句子:https://www.nanss.com/yulu/2222.html
八个字早安心语:https://www.nanss.com/wenan/1615.html
饮食养生:https://www.nanss.com/yinshi/95.html
伤感昵称:https://www.nanss.com/mingcheng/1372.html
祝愿未来可期的句子:https://www.nanss.com/shenghuo/101.html
未来的我:https://www.nanss.com/yuedu/62.html