一、創(chuàng)建子分區(qū)

子分區(qū)由兩種創(chuàng)建方法，一種是不定義每個(gè)子分區(qū)子分區(qū)的名字和路徑由分區(qū)決定，二是定義每個(gè)子分區(qū)的分區(qū)名和各自的路徑

1.不定義每個(gè)子分區(qū)

復(fù)制代碼 
CREATE TABLE tb_sub (id INT, purchased DATE)
    PARTITION BY RANGE( YEAR(purchased) )
    SUBPARTITION BY HASH( TO_DAYS(purchased) )
    SUBPARTITIONS 2 (
        PARTITION p0 VALUES LESS THAN (1990),
        PARTITION p1 VALUES LESS THAN (2000),
        PARTITION p2 VALUES LESS THAN MAXVALUE
    );
復(fù)制代碼 
SELECT PARTITION_NAME,PARTITION_METHOD,PARTITION_EXPRESSION,PARTITION_DESCRIPTION,TABLE_ROWS,SUBPARTITION_NAME,SUBPARTITION_METHOD,SUBPARTITION_EXPRESSION 
FROM information_schema.PARTITIONS WHERE TABLE_SCHEMA=SCHEMA() AND TABLE_NAME='tb_sub
        		
網(wǎng)友評論