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

This article mainly introduces "what mysql range partition refers to". In daily operation, I believe many people have doubts about what mysql range partition refers to. Xiaobian consulted all kinds of information and sorted out simple and easy operation methods. I hope to help you answer the doubts of "what mysql range partition refers to"! Next, please follow the small series to learn together!

1. Based on the given interval boundary, several continuous interval ranges are obtained, and the data is distributed to different partitions according to the falling point of the partition key.

The range partition is primarily used for partitioning date columns.

Range partitioning is achieved by using PARTITION BY RANGE(expr).

Where expr can be a column value, or an expression based on a column value and returning an integer value, such as YEAR(date).

examples

CREATE TABLE `Order` ( `id` INT NOT NULL AUTO_INCREMENT, `partition_key` INT NOT NULL, `amt` DECIMAL(5) NULL) PARTITION BY RANGE(partition_key)PARTITIONS 5( PARTITION part0 VALUES LESS THAN(201901), PARTITION part1 VALUES LESS THAN(201902), PARTITION part2 VALUES LESS THAN(201903), PARTITION part3 VALUES LESS THAN(201904), PARTITION part4 VALUES LESS THAN(201905), PARTITION part4 VALUES LESS THAN MAXVALUE; INSERT INTO `Order`(`id`, `partition_key`, `amt`) VALUES ('1', '201901', '1000');INSERT INTO `Order`(`id`, `partition_key`, `amt`) VALUES ('2',' 201902','800');INSERT INTO `Order` (`id`, `partition_key`, `amt`) VALUES ('3', '201903',' 1200'); At this point, the study of "what mysql range partition refers to" is over, hoping to solve everyone's doubts. Theory and practice can better match to help you learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

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.