如何使现有的mysql表中的月份分区？ [英] How make month wise partitioning in existing mysql table?

问题描述

我有一张包含数十万条记录的表。

I have a table with hundreds of thousands of records. How to partition the table, month-wise?

推荐答案

您可以 ALTER TABLE 在其上创建新的 PARITIONS 。 p>

You can ALTER TABLE to create new PARITIONS on it.

ALTER TABLE table_name PARTITION BY RANGE (MONTH(date_column)
(
  PARTITION JAN VALUES LESS THAN (2),
  PARTITION FEB VALUES LESS THAN (3),
  ...
  PARTITION DEC VALUES LESS THAN MAXVALUE
);

这篇关于如何使现有的mysql表中的月份分区？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！