1、环境说明
MySQL5.6.33,隔离级别是RR。表结构及数据:
CREATE TABLE `t0` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`c` int(11) NOT NULL DEFAULT '0',
`d` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `c` (`c`,`d`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8
mysql> select *from t0;
+----+----+---+
| id | c | d |
+----+----+---+
| 1 | 1 | 0 |
| 2 | 3 | 0 |
| 3 | 5 | 0 |
| 4 | 7 | 0 |
| 5 | 10 | 0 |
| 6 | 12 | 0 |
| 7 | 14 | 0 |
| 8 | 16 | 0 |
+----+----+---+
8 rows in set (0.00 sec)