MySQL 8 Administrator???s Guide

LIST COLUMN partitioning

In this type of partitioning, lists of columns are used in the table partitioning definition, and similar to the RANGE COLUMN the value list for the respective columns must be provided. Similar to RANGE COLUMN, column types other than integer types can be used—that is, the string, date, and datetime column types.

Suppose you have the requirement that a business has spread over 12 cities, and for marketing purposes you manage them with four zones of three cities as follows:

• Zone 1 with cities: Ahmedabad, Surat, Mumbai
• Zone 2 with cities: Delhi, Gurgaon, Punjab
• Zone 3 with cities: Kolkata, Mizoram, Hyderabad
• Zone 4 with cities: Bangalore, Chennai, Kochi

Now, create a table for the customer data that has four partitions ...