本文共 411 字,大约阅读时间需要 1 分钟。
为某列进行分区。范围这边自己定义
ALTER TABLE ts partition by RANGE(id)
(PARTITION p9 VALUES LESS THAN (10000) ,
PARTITION p10 VALUES LESS THAN (20000) , PARTITION p11 VALUES LESS THAN MAXVALUE )查看建立的分区
SELECT
partition_name part, partition_expression expr, partition_description descr, table_rows FROM INFORMATION_SCHEMA.partitions WHERE TABLE_SCHEMA = SCHEMA() AND TABLE_NAME='ts'
查询某一分区下的数据
select * from ts partition(p10);
转载地址:http://ilvbi.baihongyu.com/