SELECT
partition_name part,
partition_expression expr,
partition_description descr,
table_rows
FROM
information_schema.PARTITIONS
WHERE
table_schema =SCHEMA()AND table_name ='表名';
创建range分区 —— 分区字段为整型
DROPTABLEIFEXISTS`range_emp`;CREATETABLE`range_emp`(`id`int(10)unsignedNOTNULLAUTO_INCREMENT,`empno`mediumint(8)unsignedNOTNULLDEFAULT'0',`empname`varchar(20)NOTNULLDEFAULT'',`job`varchar(9)NOTNULLDEFAULT'',`mgr`mediumint(8)unsignedNOTNULLDEFAULT'0',`hiredate`datetimeNOTNULL,`sal`decimal(7,2)NOTNULL,`comn`decimal(7,2)NOTNULL,`depno`mediumint(8)unsignedNOTNULLDEFAULT'0',PRIMARYKEY(`id`))ENGINE=InnoDBAUTO_INCREMENT=6000001DEFAULTCHARSET=utf8
PARTITIONBY RANGE (id)(PARTITION part0 VALUES LESS THAN (500000),PARTITION part1 VALUES LESS THAN (1000000),PARTITION part2 VALUES LESS THAN (1500000),PARTITION part3 VALUES LESS THAN (2000000),PARTITION part4 VALUES LESS THAN (2500000),PARTITION part5 VALUES LESS THAN (3000000),PARTITION part6 VALUES LESS THAN (3500000),PARTITION part7 VALUES LESS THAN (4000000),PARTITION part8 VALUES LESS THAN (4500000),PARTITION part9 VALUES LESS THAN (5000000),PARTITION part10 VALUES LESS THAN (5500000),PARTITION part11 VALUES LESS THAN MAXVALUE);