mysql索引

参考文献来自https://www.cnblogs.com/morewindows0/p/9223671.html

下面为自己做的测试，记下来以防忘记

EXPLAIN select * from suoyin_test where c2='a1'

---

EXPLAIN select * from suoyin_test where c2='a1' and c1='a1'

---

EXPLAIN select * from suoyin_test where c1 like 'a1%' and c2='a1' 

---

EXPLAIN select * from suoyin_test where c1 like 'a1%' and c3='a1' 

---

 

EXPLAIN select * from suoyin_test where c1='a1%' and c2='a1' ORDER BY c3

---

EXPLAIN select * from suoyin_test where c1='a1%' and c3='a1' ORDER BY c2

---

 

转载于:https://www.cnblogs.com/bzdfn/p/9955194.html