mysql 查看分区数据

-- 查看表的分区信息
SHOW CREATE TABLE table_name;

-- 查看表的分区详细信息
SELECT * FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA = 'database_name' AND TABLE_NAME = 'table_name';

-- 查看特定分区的详细数据
SELECT * FROM table_name PARTITION (partition_name);

-- 创建分区表
CREATE TABLE logs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    log_date DATE,
    message TEXT
) PARTITION BY RANGE (YEAR(log_date)) (
    PARTITION p0 VALUES LESS THAN (2020),
    PARTITION p1 VALUES LESS THAN (2021),
    PARTITION p2 VALUES LESS THAN (2022),
    PARTITION p3 VALUES LESS THAN MAXVALUE
);

-- 查看分区信息
SHOW CREATE TABLE logs;

-- 查看分区详细信息
SELECT * FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA = 'your_database' AND TABLE_NAME = 'logs';

-- 查看特定分区的详细数据
SELECT * FROM logs PARTITION (p2);