MySQL 8 Administrator???s Guide

LIST partitioning

As the name states, LIST partitioning uses lists for table partitioning. The list is comma separated integer values defined while partitioning with VALUES IN (value_list); here, value_list refers to comma separated integer literals.

LIST partitioning is similar to RANGE partitioning in many ways, but there are differences. The operator used in each partitioning is different. The operator uses a list of comma separated values to be matched with the column value or the partition expression evaluating to integer value.

Considering the employee table as an example, the basic definition for the table using the create table syntax will be as follows:

CREATE TABLE employee (    employee_id INT NOT NULL,    first_name VARCHAR(30), last_name ...