explain SELECT * FROM `city`;
#主键查询
explain SELECT * FROM `city` where ID=5;
#索引查询
explain SELECT * FROM city where CountryCode='NLD';
#主键范围查询
explain SELECT * FROM city where ID>5 and ID<20 ;
#非索引范围查询
explain SELECT * FROM city where Population>193238 and Population<200000 ;
12-27
1万+
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
04-19
04-19
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交