mysql hash表分区创建&使用

CREATE TABLE tbhash (
 id INT NOT NULL,
 store_id INT
 )
PARTITION BY HASH(store_id)
PARTITIONS 4；

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='tbhash';

select * from tbhash partition (p0) ;