MySQL查询语句中的引号对索引使用的影响.
# explain select * from t1 where user_ip=123 limit 1; +----+-------------+-------------+------+---------------+------+---------+------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +---…