mysql 联合索引查询规则

联合索引

explain select *
from test1
where   a = 1 and b = 2 and d = 20

• 未建索引情况下：
• 
• 建了abd索引的情况下：用上了abd的索引，而且长度为12，整个索引都用上了，type类型变为 ref
• 

explain select *
from test1
where   a = 1 and b > 2 and d