mysql如何查看表分区数据

SHOW CREATE TABLE your_table_name;

EXPLAIN SELECT * FROM your_table_name WHERE partition_key = 'value';

SELECT * FROM your_table_name PARTITION (partition_name);

SELECT * FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME = 'your_table_name';

-- 创建示例分区表
CREATE TABLE sales (
    sale_id INT AUTO_INCREMENT,
    sale_date DATE NOT NULL,
    amount DECIMAL(10,2) NOT NULL,
    PRIMARY KEY (sale_id, sale_date)
) PARTITION BY RANGE (TO_DAYS(sale_date)) (
    PARTITION p0 VALUES LESS THAN (TO_DAYS('2020-01-01')),
    PARTITION p1 VALUES LESS THAN (TO_DAYS('2021-01-01')),
    PARTITION p2 VALUES LESS THAN MAXVALUE
);

-- 查询2020年的销售数据
SELECT * FROM sales WHERE sale_date BETWEEN '2020-01-01' AND '2020-12-31';

-- 直接查询特定分区
SELECT * FROM sales PARTITION (p1);