For a fancy application we want to query a chunk of rows from a table and therefore we need the minimum and the maximum of the Primary Key of these rows.
Because InnoDB is an Index Organized Table or Index Clustered Table we know that this access will use the Primary Key. But to be sure and to be compliant with the standard (and compatible) we use and ORDER BY on the Primary Key.
MySQL 5.7
First we create some test data:
mysql> CREATE TABLE t_my (
ID CHAR(32) NOT NULL PRIMARY KEY
) ENGINE = InnoDB; …
