mysql 有索引没走索引 更新锁全表
Session 1:mysql> select connection_id();+-----------------+| connection_id() |+-----------------+| 2 |+-----------------+1 row in set (0.00 sec)mysql> start transaction;Query