MySQL 8 Administrator???s Guide

RANGE partitioning

In this type of partitioning, as the name states, RANGE is given in an expression that evaluates whether a value lies in the given range or not. Ranges are defined with the VALUES LESS THAN operator and they should not be overlapping and contiguous.

For the next few examples, suppose we are creating a table holding employee personal records for 25 food stores. The stores are numbered from 1 to 25 and is a chain of 25 food stores, as shown in the following block:

CREATE TABLE employee (    employee_id INT NOT NULL,    first_name VARCHAR(30),    last_name VARCHAR(30),    hired_date DATE NOT NULL DEFAULT '1990-01-01',    termination_date DATE NOT NULL DEFAULT '9999-12-31',    job_code INT NOT NULL,    store_id INT NOT NULL);

Now let's do partitioning ...