mysql的in会让索引失效吗？不会！ 看结果：

mysql> desc select * from tb_province where name in ('lily3', 'lily2', 'lily1');+----+-------------+-------------+------------+------+---------------+------+---------+------+--------+----------+-------------+| id | select_type | table    | partitions | type | possible_keys | key | key_len | ref | rows  | filtered | Extra    |+----+-------------+-------------+------------+------+---------------+------+---------+------+--------+----------+-------------+| 1 | SIMPLE   | tb_province | NULL    | ALL | NULL     | NULL | NULL  | NULL | 108780 |  30.00 | Using where |+----+-------------+-------------+------------+------+---------------+------+---------+------+--------+----------+-------------+1 row in set, 1 warning (0.00 sec)mysql> alter table tb_province add index g(name);Query OK, 0 rows affected (0.29 sec)Records: 0 Duplicates: 0 Warnings: 0mysql> desc select * from tb_province where name in ('lily3', 'lily2', 'lily1');+----+-------------+-------------+------------+-------+---------------+------+---------+------+------+----------+-----------------------+| id | select_type | table    | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra         |+----+-------------+-------------+------------+-------+---------------+------+---------+------+------+----------+-----------------------+| 1 | SIMPLE   | tb_province | NULL    | range | g       | g  | 34   | NULL |  3 |  100.00 | Using index condition |+----+-------------+-------------+------------+-------+---------------+------+---------+------+------+----------+-----------------------+1 row in set, 1 warning (0.00 sec)mysql> 
mysql> select * from tb_province where name in ('lily3', 'lily2', 'lily1');+----+-------+-------+------+------+------+------+------+------+------+------+------+------+------+| id | name | score | x  | x1  | x2  | x3  | x4  | x5  | x6  | x7  | x8  | x9  | x10 |+----+-------+-------+------+------+------+------+------+------+------+------+------+------+------+| 1 | lily1 |   1 |  0 |  0 |  0 |  0 |  0 |  0 |  0 |  0 |  0 |  0 |  0 || 2 | lily2 |   2 |  0 |  0 |  0 |  0 |  0 |  0 |  0 |  0 |  0 |  0 |  0 || 3 | lily3 |   3 |  0 |  0 |  0 |  0 |  0 |  0 |  0 |  0 |  0 |  0 |  0 |+----+-------+-------+------+------+------+------+------+------+------+------+------+------+------+3 rows in set (0.00 sec)mysql>

更多相关文章

  1. MySQL 什么时候使用INNER JOIN 或 LEFT JOIN
  2. [android源码下载索引贴】微信+二维码那都不是事......
  3. android触控,先了解MotionEvent
  4. 系出名门 Android(安卓)系列文章索引
  5. 系出名门 Android(安卓)系列文章索引
  6. 系出名门 Android(安卓)系列文章索引
  7. 系出名门 Android(安卓)系列文章索引
  8. Android(安卓)自定义Gallery
  9. android 知识点汇总

随机推荐

  1. 外行人都能看得懂的机器学习，错过了血亏！
  2. 周末推荐阅读【第二弹】
  3. 从零单排学Redis【白银】
  4. GraphObject继承的类包括:Shape、TextBlo
  5. 从零单排学Redis【黄金】
  6. Linux定时任务邮件信息占盘磁盘
  7. 给女朋友讲解什么是Optional【JDK 8特性
  8. android Android签名证书的sha1值报错 ：不
  9. IDA调试修改内存数据
  10. 为什么需要Docker？