You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
1.2.5版本仍然不支持分区表与非分区表转换语法,SQL样例:
(1) 非分区表修改为分区表:
alter table tb_test partition by range (to_days(bill_date)) (
partition p202201 values less than (to_days('2022-02-01')) ENGINE = InnoDB,
partition p202202 values less than (to_days('2022-03-01')) ENGINE = InnoDB
);
(2) 分区表取消分区:
alter table tb_test remove partitioning;
由于此问题没有最近的活动,因此已被自动标记为陈旧。如果没有进一步的活动,会作为不活跃issue关闭。感谢你对本项目的贡献。 This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.
描述您想要的功能:
可以对普通表修改为分区表
AlTER TABLE PARTITION BY
描述您考虑过的解决/替代方案:
可参考文档,资料,引用等:
The text was updated successfully, but these errors were encountered: