MYSQL5.5 表分区问题

最新推荐文章于 2021-03-29 10:51:00 发布

weixin_33772645

最新推荐文章于 2021-03-29 10:51:00 发布

阅读量140

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/810965872/blog/143446

版权

2019独角兽企业重金招聘Python工程师标准>>>

1.字段属性为timestamp,在分区时出现异常

Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed

网上找了下好像是说timestamp类型分区时不起作用要改成DATETIME or DATE

pruning is not expected to work for tables partitioned on a TIMESTAMP column, and you should use a DATETIME or DATE column for this instead.

2.修改为datetime后出现错误提示如下

A PRIMARY KEY must include all columns in the table's partitioning function

mysql分区字段必须包含在主键中

sql如下：

ALTER TABLE Test  
PARTITION BY LIST (dayofweek(time))  
(  
  PARTITION p01 VALUES IN (1),
  PARTITION p02 VALUES IN (2),
  PARTITION p03 VALUES IN (3),
  PARTITION p04 VALUES IN (4),
  PARTITION p05 VALUES IN (5),
  PARTITION p06 VALUES IN (6),
  PARTITION p07 VALUES IN (7),
  PARTITION perr VALUES IN (0)
);

如有错误或问题，欢迎指出

转载于:https://my.oschina.net/810965872/blog/143446