nysql索引

参考文献来自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

nysql索引

原文：https://www.cnblogs.com/bzdfn/p/9955194.html