以 innodb 为例。
CREATE TABLE `test` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`age` int(11) unsigned NOT NULL,
`name` varchar(30) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `idx_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
插入下列数据
mysql> select * from test;
+----+-----+-------+
| id | age | name |
+----+-----+-------+
| 15 | 34 | Bob |
| 18 | 77 | Alice |
| 20 | 5 | Jim |
| 30 | 91 | Eric |
| 49 | 22 | Tom |
| 50 | 89 | Rose |
+----+-----+-------+
6 rows in set (0.00 sec)
因为主键是单调递增的,所以这里会以主键聚集,如图