-- 注意!!! 不管 字段的使用是什么顺序 都可以使用到索引,只要用到索引的第一个字段就行
explain SELECT * FROM ywj_test where age = '20003'; -- 用不到索引!!!
explain SELECT * FROM ywj_test where age = '1' and city = '20003'; -- 用不到索引!!!
explain SELECT * FROM ywj_test where name = '1' and city = '20003'; -- 用到索引
explain SELECT * FROM ywj_test where name = '1' and age = '20003'; -- 用到索引
explain SELECT * FROM ywj_test where age = '1' and name = '20003'; -- 用到索引
explain SELECT * FROM ywj_test where age = '1' and city = '12' and name = '20003'; -- 用到索引