MySQL 5.1 分区

MySQL 5.1是一个功能强大的关系型数据库管理系统，它引入了分区功能，使得数据库的管理更加灵活和高效。分区可以将大型数据表分割成更小的管理单元，提高查询性能和管理效率。本文将介绍MySQL 5.1的分区功能及其应用案例。

sql
CREATE TABLE orders (
    id INT NOT NULL AUTO_INCREMENT,
    order_date DATE,
    customer_id INT,
    amount DECIMAL(10, 2),
    PRIMARY KEY (id, order_date)
)
PARTITION BY RANGE (YEAR(order_date)) (
    PARTITION p0 VALUES LESS THAN (2010),
    PARTITION p1 VALUES LESS THAN (2011),
    PARTITION p2 VALUES LESS THAN (2012),
    PARTITION p3 VALUES LESS THAN (2013),
    PARTITION p4 VALUES LESS THAN MAXVALUE
);

sql
INSERT INTO orders (order_date, customer_id, amount)
VALUES ('2010-01-01', 1, 100.00),
       ('2011-03-15', 2, 200.00),
       ('2012-06-30', 3, 300.00),
       ('2013-12-25', 4, 400.00);

sql
SELECT *
FROM orders
WHERE order_date BETWEEN '2010-01-01' AND '2012-12-31';