MySQL哪些语句走索引_mysql哪些语句使用了索引呢

------为表中的字段增加默认值语法-- alter table account modify income int(10) not null default '0'; ------mysql哪些语句使用了索引呢？ mysql> explain select * from account where income  between 6000000 and 7000000; +----+-------------+---------+------+---------------+------+---------+------+------+-------------+ | id | select_type | table   | type | possible_keys | key  | key_len | ref  | rows | Extra       | +----+-------------+---------+------+---------------+------+---------+------+------+-------------+ |  1 | SIMPLE      | account | ALL  | income        | NULL | NULL    | NULL |    6 | Using where | +----+-------------+---------+------+---------------+------+---------+------+------+-------------+ 1 row in set (0.00 sec) mysql> explain select * from account where income>6000000 and income<7000000; +----+-------------+---------+-------+---------------+--------+---------+------+------+-----------------------+ | id | select_type | table   | type  | possible_keys | key    | key_len | ref  | rows | Extra                 | +----+-------------+---------+-------+---------------+--------+---------+------+------+-----------------------+ |  1 | SIMPLE      | account | range | income        | income | 4       | NULL |    1 | Using index condition | +----+-------------+---------+-------+---------------+--------+---------+------+------+-----------------------+ 1 row in set (0.00 sec) mysql> explain select * from account where income>6000000; +----+-------------+---------+------+---------------+------+---------+------+------+-------------+ | id | select_type | table   | type | possible_keys | key  | key_len | ref  | rows | Extra       | +----+-------------+---------+------+---------------+------+---------+------+------+-------------+ |  1 | SIMPLE      | account | ALL  | income        | NULL | NULL    | NULL |    6 | Using where | +----+-------------+---------+------+---------------+------+---------+------+------+-------------+ 1 row in set (0.00 sec) mysql> explain select * from account where income>=6000000; +----+-------------+---------+------+---------------+------+---------+------+------+-------------+ | id | select_type | table   | type | possible_keys | key  | key_len | ref  | rows | Extra       | +----+-------------+---------+------+---------------+------+---------+------+------+-------------+ |  1 | SIMPLE      | account | ALL  | income        | NULL | NULL    | NULL |    6 | Using where | +----+-------------+---------+------+---------------+------+---------+------+------+-------------+ 1 row in set (0.00 sec) mysql> explain select * from account where income<6000000; +----+-------------+---------+-------+---------------+--------+---------+------+------+-----------------------+ | id | select_type | table   | type  | possible_keys | key    | key_len | ref  | rows | Extra                 | +----+-------------+---------+-------+---------------+--------+---------+------+------+-----------------------+ |  1 | SIMPLE      | account | range | income        | income | 4       | NULL |    2 | Using index condition | +----+-------------+---------+-------+---------------+--------+---------+------+------+-----------------------+ 1 row in set (0.00 sec) mysql> explain select * from account where income<=6000000; +----+-------------+---------+------+---------------+------+---------+------+------+-------------+ | id | select_type | table   | type | possible_keys | key  | key_len | ref  | rows | Extra       | +----+-------------+---------+------+---------------+------+---------+------+------+-------------+ |  1 | SIMPLE      | account | ALL  | income        | NULL | NULL    | NULL |    6 | Using where | +----+-------------+---------+------+---------------+------+---------+------+------+-------------+ 1 row in set (0.00 sec) 可以看出，使用 也使用了索引 =号用了索引