Shulou(Shulou.com)05/31 Report--

This article mainly introduces the relevant knowledge of "what is mysql list partition". The editor shows you the operation process through an actual case. The operation method is simple, fast and practical. I hope this article "what is mysql list partition" can help you solve the problem.

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); this is the end of the introduction of "what is mysql list Division". Thank you for your reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.