How to realize list Partition in mysql

This article mainly introduces how to achieve list partition in mysql, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to know about it.

1. Each partition of the list partition must be clearly defined, based on the enumerated values list partition, through the use of PARTITION BY LIST (expr).

2. Any values to be matched must be found in the values list.

Example

Create table user (an int (11), b int (11)) partition by list (b) (partition p0 values in, partition p1 values in) Thank you for reading this article carefully. I hope the article "how to achieve list Partition in mysql" shared by the editor will be helpful to you. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!