mysql多字段分区

create talbe rc3 (   

    a int,

    b int

)

partition by range columns(a, b) (

    partition p01 values less than (0, 10),

    partition p02 values less than (10, 10),

    partition p03 values less than (10, 20),

    partition p04 values less than (10, 35),

    partition p05 values less than (10, maxvalue),

    partition p06 values less than (maxvalue, maxvalue),

);

insert into rc3(a, b) values(1, 10);

select (1, 10) < (10, 10) from dual;

-- 根据结果存放到p02分区上了

select

    partition_name,

    partition_expression,

    partition_description,

    table_rows

from information_schema.partitions

where table_schema = schema() and table_name = 'rc3';