# explain select * from t1 where user_ip=123 limit 1;-------------------------------------------------------------------------------------------| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |-------
# explain select * from t1 where user_ip=123 limit 1; +----+-------------+-------------+------+---------------+------+---------+------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-------------+------+---------------+------+---------+------+------+-------------+ | 1 | SIMPLE | t1 | ALL | user_ip | NULL | NULL | NULL | 262 | Using where | +----+-------------+-------------+------+---------------+------+---------+------+------+-------------+ 1 row in set (0.00 sec) # explain select * from t1 where user_ip='123' limit 1; +----+-------------+-------------+------+---------------+---------+---------+-------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-------------+------+---------------+---------+---------+-------+------+-------------+ | 1 | SIMPLE | t1 | ref | user_ip | user_ip | 47 | const | 1 | Using where | +----+-------------+-------------+------+---------------+---------+---------+-------+------+-------------+ 1 row in set (0.01 sec)
可以看到, user_ip 字段是 varchar 类型. 查询时, 如果这个字段的值没有加引号, mysql 就不会使用索引. mysql 为什么会有这种致命的策略?!
—– 更新: —–
相关的文档已经找到: http://dev.mysql.com/doc/refman/5.5/en/type-conversion.html, 这里面提到和几种类型转换的情况, 字符串和数字比较都被统一转成浮点数再比较.
每个人都需要一台速度更快、更稳定的 PC。随着时间的推移，垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是，许多工具可以让 Windows 保持平稳运行。
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
852
收藏
