mysql int 索引_mysql varchar int 123 走索引吗？

最新推荐文章于 2021-12-02 14:31:33 发布

太阳脸上的斑

最新推荐文章于 2021-12-02 14:31:33 发布

阅读量102

点赞数

文章标签： mysql int 索引

本文链接：https://blog.csdn.net/weixin_36179394/article/details/113165097

版权

mysql> explain select * from gyl where str=123123 limit 1; + ----+-------------+-------+------+---------------+------+---------+------+--------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | + ----+-------------+-------+------+---------------+------+---------+------+--------+-------------+ | 1 | SIMPLE | gyl | ALL | str_x | NULL | NULL | NULL | 262756 | Using where | + ----+-------------+-------+------+---------------+------+---------+------+--------+-------------+ 1 row in set mysql> explain select * from gyl where str= '123123' limit 1; + ----+-------------+-------+------+---------------+-------+---------+-------+--------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | + ----+-------------+-------+------+---------------+-------+---------+-------+--------+-------------+ | 1 | SIMPLE | gyl | ref | str_x | str_x | 257 | const | 131378 | Using where | + ----+-------------+-------+------+---------------+-------+---------+-------+--------+-------------+ 1 row in set mysql> explain select * from gyl where num= '12313' limit 1;; + ----+-------------+-------+------+---------------+-------+---------+-------+--------+-------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | + ----+-------------+-------+------+---------------+-------+---------+-------+--------+-------+ | 1 | SIMPLE | gyl | ref | num_x | num_x | 4 | const | 131378 | | + ----+-------------+-------+------+---------------+-------+---------+-------+--------+-------+ 1 row in set 1065 - Query was empty mysql> explain select * from gyl where num=12313 limit 1; + ----+-------------+-------+------+---------------+-------+---------+-------+--------+-------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | + ----+-------------+-------+------+---------------+-------+---------+-------+--------+-------+ | 1 | SIMPLE | gyl | ref | num_x | num_x | 4 | const | 131378 | | + ----+-------------+-------+------+---------------+-------+---------+-------+--------+-------+ 1 row in set