MySQL 8 Administrator???s Guide

COLUMNS partitioning

As the name suggests, this type of partitioning uses columns themselves. We can use two versions of column partitioning. One is RANGE COLUMN and the other is LIST COLUMN. In addition to both RANGE COLUMN and LIST COLUMN partitioning, MySQL 8 supports using non-integer types of column that can be used to define value ranges or list values. The list of permitted data types are as follows:

• All column types of INT, BIGINT, MEDIUMINT, SMALLINT, and TINYINT are supported for the RANGE and LIST partitioning columns, but other numeric column types such as FLOAT or DECIMAL are not supported
• DATE and DATETIME are supported but other column types relating to date and time are not supported as partitioning columns
• The string column ...