mysql字符串分区

Rudolf__

于 2022-11-29 19:38:17 发布

阅读量743

点赞数

分类专栏： mysql 文章标签： mysql 数据库 java

本文链接：https://blog.csdn.net/Rudolf__/article/details/128103902

版权

mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1.分区语句

CREATE TABLE `v` (
  id bigint(20) NOT NULL AUTO_INCREMENT,
  uid varchar(60) NOT NULL,
	bar varchar(100),
  PRIMARY KEY (`id`,uid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
PARTITION BY KEY (uid)
PARTITIONS 10;

2.插入数据

insert into v(uid,bar) values('aaccbbbddadsa12','123'),('dafasd','123'),('aaccbbbddadsa12','123'),('123','123'),('dda','123'),('aaccbbbddadsa12','123'),('64dw','123');

3.查看分区表情况

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

4.参考字类
https://www.jb51.net/article/244282.htm
https://www.nuomiphp.com/eplan/660204.html